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...
Category Archives : Qlik Sense RSS feed for this section
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 ...
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...