QVDs form a crucial part of many Qlik implementations, and are an ideal way of persisting data in both Sense and QlikView. What you may not be aware of though is there is an XML header to these files containing useful information. This post explores this header, and has free downloads to load them into Sense and QlikView. […]

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 the past nine years as a consultant, I’ve built up a treasure trove of resources that have helped me to master Qlik Sense and QlikView. Here’s the full list, I hope you find it 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. Q-On Training Center Collaborative online training courses delivered by highly respected Qlik pros including Miguel García, Barry Harmsen, Rob Wunderlich and Ralf Becher. → See The [...]

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. […]

Over the years I have seen many QlikView apps, created by many different developers and analysts. Even now, I still come across apps where silly mistakes are made. Here is my list of things that really shouldn’t be happening in your apps – and how to fix them. […]

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. […]

You may already know that you can send alerts via email using QlikView when certain conditions are met. These are useful, but it is not obvious how to include data relating to the alert. This post and example app explains how. […]

QlikView is one of those products that is quick to get started with, but takes years of putting things into practice to really get skilled in. So, how can you boost your skills to become a Qlik Expert? […]