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