Scatter Plots are good
I was helping a customer recently when I was shown a Pie Chart they had developed in QlikSense showing product returns, they liked the chart although they asked how they […]
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 […]
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 […]
Moving Forward With Qlik Sense
I’ve been working with QlikView for over five years now and since it’s launch a couple of years ago I’ve had some opportunity to learn Qlik Sense but very little […]
User Controlled Charts in QlikView
Hello, Recently I’ve been blogging about where to store variables and why (I think) a data island is the best way forward. The original idea for a data island comes […]
Brian Booden, Sense Extensions – Hexagonal Binning
Hello, The last QlikDevGroup event in London on the 23rd September 2015 had some fantastic presentations. In this video Brian Booden talks about his Sense extension Hex Binning and the development […]
Date Comparison with a Powerful Calendar
About 18 Months ago I shared a calendar which allows you to calculate values over many different periods. Yesterday, Last Month, Last Month Comparative, 52 Weeks ago, etc. This proves […]
