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 […]
Tag Archives: data
How does Set Analysis Work in QlikView
Hi In previous posts I’ve talked about the QlikView Engine Explaining Symbol and Data tables and how QlikView understand Selections using the Logical Inference Here we will be taking the concept […]
Selections and Logical Inference
Hi In a previous post I talked about the QlikView Engine and Explained Symbol and Data tables……. When selections are made on a QlikView dashboard you see the Green, Grey and White […]
The QlikView Engine
Hi everyone, Understanding how the QlikView engine stores and processes the data really helps you create efficient QlikView dashboards. Understandably a Qlik developer never needs to know all the detail of […]
Flag Latest Record using QlikView Script
Often you’ll have a number of records for effectively the same thing and you’re only interested in the latest one. For example each day you count widgets and the customer […]
Joins, Concatenation and the Applymap function
When you first start using QlikView (and this applies to the start of a new project) your data structure will probably be a simple snowflake schema where data is loaded […]
The Optimal QlikView Data Structure
It doesn’t take long to discover that organising your data correctly within QlikView is the secret to success. A couple of well known phrases always spring to mind: The 80 […]
Loading Multiple QVD files
Hi, all of my Qlik applications have QVD data staged and prepared in advance. Here I will go through how I import them efficiently into QlikView. For now I’ll assume […]
Table Analyser
Before development can begin you need to know your data. Whilst working on a contract a number of years ago I created an application that may help. Be warned it can […]
