76 – Remove Unused Fields

76 – Remove Unused Fields

I can’t tell you how many times a client has said to leave a field in the data model just in case they want to use it later. Just don’t do it. Take it out now, if they want to use it later, then bring it in later. You can easily set up the app so that it is a super...
77 – Keys

77 – Keys

Here are a few things I strongly suggest in working with Qlik key fields. Make separate key fields* Prefix the field with % Set HidePrefix variable to % Use AutoNumber Because of how the association engine works, you should never use a key field in an expression. It...
78 – AutoNumber

78 – AutoNumber

To follow up on my cardinality post, a very useful function is AutoNumber. AutoNumber will create an integer for each distinct value in your defined namespace, which is usually a field. The second parameter, allows you to define the namespace, which means you can use...
79 – Cardinality

79 – Cardinality

One of the key things to understand when trying to tune a Qlik app for performance is understanding the innerworkings. If you haven’t done so already, I very strongly suggest you read Henric’s blog Symbol Tables and Bit-Stuffed Pointers which goes into detail on how...
80 – Do While

80 – Do While

Most loops you will see are For loops. These are great if you can programmatically determine the number of loops you need to do. For example the number of rows of a table. However, what if you need to loop as long as it takes to finish? You don’t know how long it will...