Category Archives : Qlik Sense RSS feed for this section

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

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