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 […]
Category Archives: Create
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 […]
Importing Colours into Variables
Hi, Here is my very first video. I plan to run several covering the basics of flat design in QlikView. This video covers loading a flay colour scheme into variables […]
Who are QlikView Developers?
QlikView Developers are often lumped into a general ‘IT’ category. I myself take great personal delight in the fact friends and family don’t know what my role as a QlikView […]
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 […]
Calendar with flags making set analysis so very simple
Hello, Calendars are one of the first things developed when working with Qlik and most follow a similar format. Often called “Master Calendar” the name misleads as best practice design […]
Painting Space and Reference Lines
Using offset can do more than simply create waterfall charts. Recently I’ve seen a number of questions relating to Painting Space in a line chart and also how to add […]
InputField Update Macro
Recently I’ve been having great fun with input fields. For those of you not aware (which was me only a month or two ago) Input fields behave somewhat differently from […]
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 […]
Waterfall Charts
Waterfall charts are a very effective way to display information. Recently, I required one with a drill down group which caused challenges with the bar offset. Here is a link […]
