Archive by Author

59 – Default Apps

Most of us our familiar with the License Monitor and Operations Monitor dashboards.These two logging apps are automatically installed and placed in the ‘Monitoring apps’ stream. Did you kn...

60 – Subset Ratio Tip

One quick tip about data modeling. If you find things in your model are not associating right, take a look at your key fields. If you add up the subset ratio percentages of a key in each tables that i...

61 – Certificates

To be honest, when I first started out I thought certificates were a very overwhelming thing and mostly because I never messed with them. So if you are in the same boat, fear not. They are not that di...

62 – While Conditions

The While clause is an extremely powerful feature that you probably won’t use frequently, but when you do it’s a god-send. Note that this is a part of the Do..Loop scripting convention. Th...

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