Tag Archives : qlik

49 – Optimized QVD Loads

If you have been working with Qlik for a bit I am sure you have heard of QVDs. If you have been working with Qlik a while hopefully you have heard of optimized QVD loads and non-optimized QVD loads. E...

51 – Bypassing the Interpreter

Have you ever wanted to load dollar sign expansion into a field or variable? One common use case is storing expressions within a metadata table, which may contain a variable in the expression. Have yo...

52 – Natively Loading JSON

I want to start this artcile off by mentioning that this only works for flat json, meaning non-nested json hierarchies. It is possible to leverage this for nested json but takes a bit m...

55 – Quick Month Map

Here is a super quick tip. If you ever need to convert month names or prefixes to numbers or dates you can leverage the default variables and Subfield to quick create a mapping table to late...

58 – FieldValueList

This is a very neat option for loops. If you need to loop through a list of field values you can use the FieldValueList mask. This could replace using the combination of NoOfRows and Peek. That i...

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