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 […]
Category Archives: Best Practice
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 […]
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 […]
Storing Expressions Into a Data Island
Recently I talked about where to store variables once you’re ready to move your dashboard from development to live. Storing QlikView expressions into a data island will help ensure your dashboard […]
Storing Expressions In Variables
Recently I talked about where to store variables once you’re ready to move your dashboard from development to live. Storing expression into variables will help ensure your dashboard remains accurate and […]
Where to store your expressions in QlikView?
Hello, Writing expression in QlikView is pretty straight forward to do and these expression aren’t just limited to calculations either. They can also control the visibility and style of your object, […]
Count or Sum(1) – Which is best?
For years QlikView developers have been inserting a field into our Fact data tables and setting the value to 1. 1 AS %RowCount It’s now very simple to Count the […]
Organising Your QlikView Script
Hello, In this video tutorial I show you how to effectively organise your QlikView load script Note: I’ve recorded the videos in highest resolution possible. So please view them in […]
A Common QlikView Data Structure Mistake
Hi Everyone, Here I’ll will talk through a common QlikView data structure mistake, often experienced by developers new to the tool and how to fix it! QlikView associates the […]
qlikcentral 