Download Example Qlik Sense & 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!
This tool allows you to load any data into our application template and view it in the twelve page application. From KPIs to user-configurable table, everything is driven from a simple metadata spreadsheet. Just define the fields and expressions and the application creates itself.
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 Qlik Sense Data Profiler and the QlikView Data Profiler.
Analyzer Capacity Licences are a great way to give infrequent users access to your app. This app monitors capacity usage and alerts if a threshold is exceeded. This blog post explains how it is put together: Qlik Analyzer Capacity Monitor and Notify.
This application was produced to illustrate the technique of sending data as an HTML table created during the load process. A blog post describing how to create this application or apply it to other applications can be found here: Send Data from the Qlik Load Script.
This app demonstrates the new Alternate States functionality, delivered in Sense November 2018. A blog post describing how to create alternate states can be found here: Alternate States in Qlik Sense.
This app demonstrates how star equals can be used in Set Analysis so that sets can also respond to selections as well as the sets defined in code. A blog post describing this can be found here: Qlik Sense Set Analysis – Star Equals.
An app which shows various methods of generating data that can be used for testing or demonstrating functionality. A blog post with full details can be found here: Generating Test Data In Qlik Load Scripts.
This app automatically picks up log files which are contained in emails, using the Qlik IMAP Connector in Qlik Cloud. It then parses unstructured text into columns. Built for the Netgear R7000P router, but could work with others. See this post for details of how it works: Analyse Netgear Router Logs in Qlik Sense.
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.
This QlikView example shows how a Conditional Show on objects can allow a more dynamic
experience than Minimize, Maximize and Containers.
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.
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.
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.
Produced to accompany the blog post QlikView Buttons, When, Why and How, this example shows that Actions can be attached to far more than just buttons.
Produced to accompany the blog post How to Build a Cycle Group in Qlik Sense this example
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.
Produced to accompany the blog post Recipe for a Variance to Target Bar Chart, this example
shows how to build charts to display variance to a target with both absolute and percentage
values.
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 Accumulate Values in the QlikView 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.
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?.
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.
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.
A simple toggle created with Text Objects and Actions and conditional colours. Further
examples of Actions can be seen in the ‘At the Qlik of a Button’ example, above.
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’) can be split and 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.