Error Trap
If at first you don’t succeed, Error Trap! Sometimes things go wrong…. Sometimes if you wait a few seconds and try again it works. Strange but true! Here we look […]
Monthly Archives: January 2016
Cumulative Values In the Script Using Peek()
Everyone loves cumulative values on a chart and they’re are possible with an expression using the above function. This shows you how to add them to the data table in […]
The Problem with Where Not Exists
Do you know what the problem is? I use Where Not Exists all the time, typically when I’m incremental loading. (a detailed video of how to do that can be […]
Fixing Set Analysis in Qlik
Set Analysis is a very powerful tool in Qlik, put simply it allows you to pre-define selections on an expression. Typically your first type of set analysis will be simple, such as […]
Think Before You Link
Qlik is all about the data, get that right and your visualisations will be effortless! I typically bring all my data together into a Star Schema and I’ve written a […]
