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

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

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

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

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

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

To be honest, when I first started out I thought certificates were a very overwhelming thing and mostly because I never messed with them. So if you are in the same boat, fear not. They are not that di...

The While clause is an extremely powerful feature that you probably won’t use frequently, but when you do it’s a god-send. Note that this is a part of the Do..Loop scripting convention. Th...

What do you do when you need to associate multiple fields between two tables? Qlik creates a synthetic key and everyone says that’s bad! First it’s good to understand what a synthetic key ...

I’ve spent a lot of time over the years troubleshooting issues that resulted in it being because of the date format. After a while I started to make a habit of always using dates in a numerical ...