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...
Category Archives : 101 Things I Wish I Had Known Sooner RSS feed for this section
50 – Section Access Tips
I truly wonder how much time collectively the Qlik Community has spent troubleshooting Section Access...
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...
53 – Script Logs
If you didn’t know, reload logs reside in the following folders: C:\ProgramData\Qlik\Sense\Log\Script On the Qlik Engine that the application reloaded on. ~\QlikShare\ArchivedLogs\%Server_Name%\...
54 – QVD Metadata
Each QVD contains an XML header which contains metadata about that QVD. It is very common to leverage this to make a QVD Catalog dashboard to provide some overarching insight into all of the QVDs in y...
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...
56 – FileList Mask
There is a feature when doing a for each loop called FileList. It’s a way to get a list of files in a directory that matches a wildcard path. Since this is a parameter of the for each statement and...
57 – Services Restart
After working with Qlik for a long time, you’ll soon find out that restarting the services can solve a lot of unexpected behaviors and is a good starting point for environment bugs. If you’...
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...