Tag Archives : script

80 – Do While

Most loops you will see are For loops. These are great if you can programmatically determine the number of loops you need to do. For example the number of rows of a table. However, what if you need to...

81 – ApplyMap

This is a post that might be common knowledge to you, but if not this can be a crucial addition to your workflow. ApplyMap is a function that is very similar to VLookup in Excel. Essentially you can u...

84 – Executing Generated Script

This concept can be used in so many ways and can come in handy for complex situations. Essentially, with the use of dollar sign expansion, you can execute script you have programmatically built in the...

85 – Loading Entire File Content

Have you ever wanted to consume a whole file’s content into Qlik as a single value? Perhaps, a series of README files or code files which can be shown on the front end? This is a little tricky s...

86 – Preceding Load

Preceding Load allows you to perform additional load steps before initializing a table. Each step uses the output of the preceding load statement as input. Original: Load     Pick(...

88 – Renaming Fields

This is a cool little trick that I use a lot because of preference. The idea is you can rename all the fields within your Qlik application using one statement, two if you count prep work. Data: Load Â...

97 – Naming Conventions

Like most other programming languages, it is important to decide and follow some programming standards. One key standard is how to name things. Now I’m not here to say that you should name thing...

99 – Inline Load Delimiter

One thing which would have been useful years ago was knowing I could copy data directly from Excel into the load script for an Inline Load if I changed the delimiter setting in the load script. So wha...

100 – AutoGenerate

You might have noticed I used this in the last example. AutoGenerate is so useful and has so many use cases. I probably use this in every app I create: from empty stub tables , generating a new field ...

101 – Subroutines

Here is to the start of a new blog series I am doing called ‘101 Things I Wish I Had Known Sooner’. Each post will contain a straight and to the point thing that I, well… wish I had ...