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 : Qlik Sense RSS feed for this section
50 – Section Access Tips
I truly wonder how much time collectively the Qlik Community has spent troubleshooting Section Access...
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...
Exporting Data from Qlik to Database
Description This covers how to use Qlik to insert data from a Qlik table into a SQL database using script generation. This is done for all tables within a Qlik model where the Qlik and Database table ...