Prepare a new qlik project

Intro If you prepare yourself for a “seeing is believing” workshop or going to start a new qlik project. Be aware that you should prepare your work environment! System Requirements Based upon the size of your data and the number of clients you need to “size” your server or developer workstation. For a minimum developer […]

Read More →
Whale and Dolphin Watch – La Gomera

Where to go? If you ever had the wish to watch whales and dolphins in real “free” live, than one of the many places to go can be La Gomera, one of the tiny islands in the canary group. Depending on the time of the year, you can see different whales and/or dolphins. One of […]

Read More →
QlikView – Color Blend by Dimension Value

Overview Sometimes you wanna define a “color schema” by the values of a dimension. The easiest way is to generate a mapping table where each dimensionvalue gets an color assigned. Downloads First load the color table as CSV from here and save them into the same folder where you wanna create and run the QlikView […]

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 →