Qlik Sense and QlikView Examples

Download Example Qlik Sense and QlikView Apps

We have produced these Qlik examples both to illustrate answers to questions on Qlik Community and to share solutions that we have created for our clients. Some take the form of tutorials that can be followed to learn a concept or technique, others contain pre-canned visualisations that you can copy and paste into your own applications.

If you find any of these apps useful, please do rate them on Qlik Community!

Sometimes you want to flex the dimension on your chart based on selections. The Drill function in QlikView allows you to show days within a month when only a month is available – but what if you want days from the end of one month and the start of another. This example shows a more flexible way.

Produced to accompany the blog post How To Build a Cycle Group in Qlik Sense this examples shows how a data island of dimension names can be used in a Filter Object to select the Dimension for multiple charts.

Normally QlikView alerts are just used to send notifications about events. However, using the AGGR and the CONCAT functions full data sets can be emailed out to users when criteria are met. This is described fully in the blog post Sending Data In QlikView Alerts

Example showing how tabs can be grouped and colour coded and a menu be employed to only show one group of tabs at a time – making navigation of a QlikView app far simpler. This example also shows how different users can be shown different tab options based on their login. This is done with a simple inline load.

This example was created to illustrate the blog post about accumulation using the data model. The post describes how you can show rolling Moving Annual Totals (MAT’s), average bars and true point in time accumulations (without having to go back to day zero). The QlikView app shows each of these techniques working over a simple data set.

Expanding on the dynamic date example above this application shows how a date dimension can flex to show data by the hour when only a few days are selected. It also shows an alternative to flexing the dimension with thin bars in QlikView 11.

When using Set Analysis on dates it is often better to use dates stored in variables to deriving dates from the source data or a data island. This example shows how Actions can be used to manipulate dates with next and previous day buttons as well as the ability to skip months.

A question was posed on QlikCommunity as to how an Object could be created that behaved like a List Box, but contained values from more than one field. This Shared QlikView was a response to that question.

Posted as an example to a question on QlikCommunity this example shows how survey or exam data where multiple results are contained in a single field (eg. ‘AABDDU’) these can be split out shown separately. Shows use of the CrossTable and ApplyMap functions.

This app loads QlikView Structure files, that can be exported straight from QlikView Desktop. The rationale behind this application is explained in the blog post Understanding QlikView Data Structures.