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.
-
Generic Data Profiler
This tool gives a list of all tables, the fields in those tables and the values of each field in a dynamic view. There are also blog posts to accompany this app for the QlikView Data Profiler and the Qlik Sense Data Profiler.
-
Current Selections Dynamic Display
Having a current selections box on every screen takes a lot of space. Sometimes it is useful to see all selections. This example is an elegant way of showing and amending selections.
-
Show and Hide Windows Dynamically
This QlikView example shows how a Conditional Show on objects can allow a more dynamic experience than Minimize, Maximize and Containers.
-
Dynamic Date Dimension
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.
-
Simple Year To Date Example (Set Analysis)
Set Analysis is a very powerful set of syntax for analysing data in different groups at the same time. This example shows how it can be used to do a simple YTD table.
-
Set Analysis – Prior Period Comparison
Following on from the simple Set Analysis above this example takes the use of the syntax further. Comparing current YTD to prior YTD and current month to prior month etc.
-
At the Qlik of a Button
Produced to accompany the blog post QlikView Buttons, When, Why and How, this examples shows that Actions can be attached to far more than just buttons.
-
Grand Slam Tennis – Cycle Group In Qlik Sense
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.
-
Send Data In A QlikView Alert
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
-
Bar Charts Showing Actual vs. Target
Produced to accompany the blog post Recipe for a Variance To Target Bar Chart, this examples shows how to build charts to display variance to a target with both absolute and percentage values.
-
Show and Hide Sheets based on User or Menu
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.
-
Accumulate Values In The Data Model
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.
-
The Power Of Yellow (Show Alternatives)
A simple example of how Show Alternatives can help to highlight information that could otherwise be lost if shown in grey. Built to illustrate the blog post The Power Of…. Yellow?.
-
Export Chart and Sheet to an Image File
Originally developed to enable a client to export static images to a wallboard, this example shows how macro code can be used to automate the export of PNG files of charts or entire sheets on reload.
-
Dynamic Date Dimension – With Hours
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.
-
Using Actions To Change Date Variables
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.
-
Multi Column ListBox
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.
-
Set Variable with an Action on a Button
A simple toggle created with Text Objects and Actions and conditional colours. Further examples of Actions can be seen in the Qlik Of A Button example, above.
-
Split Values from a String and ApplyMap to Results
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.
-
View QlikView Data Model Structure Files
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.