75 – Arrays

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: SET vCount = 'One','Two','Three'; for each i in vCount     Trace ------------ $(i); Next i The second way is by using a […]

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

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 can return some very unexpected results. So […]

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 it across multiple fields while keeping data association integrity. The […]

79 – Cardinality

One of the key things to understand when trying to tune a Qlik app for performance is understanding the inner-workings. 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 Qlik stores data. After grasping that, it starts to makes […]

Me.

You know, I started this blog for several reasons: learning, expanding my social media and professional presence, creating some sense of an archive, etc… But I think one reason I should’ve done it for is clarity. Clarity? What do I mean by clarity… I think I mean it in several ways. I think I want […]

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

81 – ApplyMap

This is a post that might be common knowledge to you, but if not this can be a crucial addition to your workflow. ApplyMap is a function that is very similar to VLookup in Excel. Essentially you can utilize a mapping table that you can bulk find and replace, provide and input and receive and […]

82 – Placeholder Tables

You might have noticed me using these in a few of the previous examples. The idea is that you create an empty table that you can concatenate to. The number one reason I do this is to be explicit. I know Qlik can and will auto-concatenate, but I want to be extremely clear in what […]

83 – Over-engineering

You should keep in mind that just because you can do something, doesn’t necessarily mean you should. Try and be aware of the actual value something will provide. If it takes you 40 hours to automate something that is done manually for 5 minutes every month, it would take you 40 YEARS to see the […]