QlikView Script Sub for Dataloading

Sorry, typo in the path variable, now fixed! Enjoy the script!

Read More →
Project Documentation with github and markdown

A very important step while implementing more or less complex solutions is the availability of a documentation. While I’m really a fan of version based work, I will describe a quick an simple way, how I document my projects with github and markdown. For all of you who don’t know markdown, it’s a simple “what […]

Read More →
Lesson 11 – complex data presentation

Overview In this lesson we get to know more complex data diagrams, which are properly suited for “intergroup” analysis. Trellis Trellis graphs serve the same visualization with a uniform scale to visualize different categories. You can decide yourself which dimensions you want to “distinguish”. In the advanced settings you can define the quantity per column […]

Read More →
Lesson 10 – Standard data presentation

Overview In this lesson we will get to know some of the most common charts and how we can make them prettier. Bar graph With the help of bar graphs comparisons between individual groups of values ​​can be created quickly (quantitatively). In doing so, the orientation of the charts can create a clean representation even […]

Read More →
Lesson 9 – Basic pivot functions

 Overview In this lesson we are going to learn about the most important aggregation functions in detail and how to “modulate” them to our purpose. A short introduction into the set-analysis is going to show us one of the most powerful functionalities. Pivoting made easy To create a cross table right-click an “empty” area on […]

Read More →
Lesson 8 – Working on the User-Interface

Overview Up until now we were almost exclusively occupied with the loading of data. Starting with this lesson, we are mainly focusing on presenting and analyzing the data. General settings Activating the “Design-Toolbar” is one of the most important presettings for a QlikView designer. You can manage the visibility in the menu option “View”. Overview […]

Read More →
Lesson 7 – Exercises

Overview In this lesson you are going to repeat all you learned on your own with your acquired skills and techniques. Task 1 – Dataloader Adventure Works Create a dataloader with a connetion to the acces file – AdventureWorksSample which can be found in “Admin/Common/Libs/QVComponents/Examples/DbExtract” Qualify the datas and save them into the DataStaging (work […]

Read More →
Lesson 6 – Script Tips ‘n’ Tricks

Overview This short lesson concentrates on typical questions from practice and their possible solutions. Marking of duplicates In practice it often happens that “duplicates” for one information exist but you only want to consider the “newest” dataset. To prevent this problem, QlikView offers so called “interrecord-functions” within scripts. These allow to access previous or following […]

Read More →
Lesson 5 – Project organisation

Overview This lesson handles the general organisation and structuring of QlikView projects. Based on our longtime experience with software development and QlikView implementations, we here show our “Best Practice”. As easement for our own projects we provided an online template which enables the development of stable BI-solutions following our standards. https://github.com/FrenzelGmbH/qlik Folder structure ADMIN COMMON […]

Read More →
Lesson 4 – Structuring scripts and using functions

Overview To not lose track in longer scripts, you have the possibility to structure the script. QlikView offers you to classify via index cards. Additionally we use easy functions to enrich our datamodel. Generate an index sheet To simplify the finding of ladelogics in the script, structure the script by creating new tabs or moving […]

Read More →