This collection of posts is a subset of our Qlik Analytics Platform blog, which includes articles on QlikView, Qlik Sense and the broader analytics landscape.
Set Analysis is a powerful set of syntax which is widely used in QlikView and Qlik Sense applications, but I find that many developers are unaware one of the most useful functions. Here I explain how to use it. […]
The Ultimate List of the Web’s Best Qlik Resources Over many years as a consultant, I’ve built up a treasure trove of resources that have helped me to master the Qlik platform. Here’s some of those resources, I hope you find them useful. This guide is updated regularly. So, if you have a resource to add, let me know in the comments and I will add it to the list. Chapters CHAPTER 1 : Online Training Courses CHAPTER 2 : Classroom Training CHAPTER 3 : QlikView and Qlik Sense Blogs CHAPTER 4 : Development Tools CHAPTER 5 : Qlik Sense Resources CHAPTER 6 : Free Datasets CHAPTER 7 : Events and Meetups CHAPTER 8 : Forums and Social Media CHAPTER 9 : Video Channels CHAPTER 10: Books Online Training Courses No matter where you are in the world or how experienced you are with Qlik, these courses will help you to improve you skills fast. Qlik Continuous Classroom The Qlik Continuous Classroom is a self-service online platform that allows you to learn QlikView, Qlik Sense, and analytics methodology by role. → See The [...]
A few days after upgrading to Qlik Sense Desktop 3.0 SR1 I found that Sense was not running when clicking on it’s icon on the Taskbar. A task was starting, but no UI was appearing. I even tried re-installing without joy. The solution in the end was simple – but not at all obvious. […]
Many blog posts and tutorials on Qlik Sense focus on the data visualisation features. The load script is often omitted maybe because the script is almost identical to the QlikView load script, of which much has already been written. This post highlights some of the techniques that are common to both products. […]
The implementation of variables and dollar sign expansion in QlikView and Qlik Sense is incredibly flexible and can be used to great effect in load scripts. In this post I show how and give a recipe for a NetworkDays function that excludes public holidays. […]
There are a number of ways of showing variance to target in a dashboard. Here I show how to create a stacking bar chart which is simple to read and gives meaningful comparisons between dimensions and against target. […]
When you are viewing values by month the trend will be broken by part month values. This can be addressed by implementing a run rate calculation in your chart. This post shows you how. […]
QVD files are the backbone of any well designed QlikView application. You store your data in there and read it out again – simple. But, did you know that the QVD header holds some useful meta-data? Did you know that could be loaded into QlikView for analysis? No? Well, read on. […]
