If you are like me, you probably use SubField a lot. I had used it for years before I stumbled across one of its most powerful features in someone else’s code. If you do not provide the position parameter, it will expand a record for each delimited value. I’ve worked...
Arrays and/or Lists are very common in programming languages. In Qlik scripting there are two ways to go about creating an array of sorts. The first way is storing a list in a variable: The second way is by using a field: Source Result: The main use of these will be...
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...
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...
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...
