Archive by Author

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

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