With Qlik Sense having 5 releases a year, it can quickly become overwhelming staying up to date on the latest release. And even then, should you even be on the latest and greatest? Here is what I reco...

There will always be situations where the data you get isn’t at the same granularity as the other. The benefit of Qlik is you can leverage the associative model to account for these scenarios. S...

One of the most resource intensive functions in a chart is the If statement. In a lot of scenarios, what you can do is leverage the combination of Pick and Match to replicate the functionality while i...

There’s nothing worse than waiting for a long reload to find out you made a typo. One thing I have made a habit of is copy and pasting script items: table names, field names, variables, etc̷...

By default you need to reference the display (read: string) value of a dual field in set analysis versus the numerical value. I personally think this is a weird behavior of Qlik, however it is what it...

One good thing to know is that you can use an asterisk * within a file name. Qlik will load all the files that fit the criteria. Say you have a directory named QVD, which has all of your QVDs prepped ...

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...

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 = '...

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...

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 *Bec...