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. Either way, hopefully I can shed some of the mystery around QVDs and these two loads.

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 you needed to leverage a square bracket in an Inline Load? Maybe have had to use a quote in a variable or field value. Here is how you can get around that.

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 more elbow grease and knowledge of the schema. Since my intention is to keep these posts brief, I’ll save that for a more in-depth stand […]

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%\Script Log files have the following naming convention: %app_guid%.%reload_time%.%unknown% * I haven’t been able to determine the third parameter yet. Will update this post if I ever do. If you k...

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 your environment. To see, just select a QVD in a folder connection and change the File format from QVD […]

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 later use with an ApplyMap. and boom: Source

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 not a function, there is not a lot of information on it. If you have kept […]

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’re like me it can take a while to remember the order they should be done in. So here is the list […]

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 is assuming you only need to loop through the distinct list of values. Script Result Notice the difference how the two options handle the […]