Category Archives : 101 Things I Wish I Had Known Sooner RSS feed for this section

63 – Concatenated Keys

What do you do when you need to associate multiple fields between two tables? Qlik creates a synthetic key and everyone says that’s bad! First it’s good to understand what a synthetic key ...

64 – Functional Date Formatting

I’ve spent a lot of time over the years troubleshooting issues that resulted in it being because of the date format. After a while I started to make a habit of always using dates in a numerical ...

65 – Changing Column Width

I’ve heard a few people mention that you can’t change the column width within a table. This is definitely possible! If you haven’t stumbled on the solution yet, take a look below: I ...

67 – Create a Codebase

One of the reasons I started doing this blog was to have a place to store my random Qlik info. But even before this, over the years I have collected a number of code snippets that I can refer to whene...

68 – When to Upgrade

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

69 – Mixed Granularity

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

70 – Pick Match

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

71 – Copy Paste

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

72 – Dual Set Analysis

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