81 – ApplyMap

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 utilize a mapping table that you can bulk find and replace, provide...
82 – Placeholder Tables

82 – Placeholder Tables

You might have noticed me using these in a few of the previous examples. The idea is that you create an empty table that you can concatenate to. The number one reason I do this is to be explicit. I know Qlik can and will auto-concatenate, but I want to be extremely...
83 – Over-Engineering

83 – Over-Engineering

You should keep in mind that just because you can do something, doesn’t necessarily mean you should. Try and be aware of the actual value something will provide. If it takes you 40 hours to automate something that is done manually for 5 minutes every month, it would...
84 – Executing Generated Script

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 script or pulled in from source files. Notice...
85 – Loading Entire File Content

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 since Qlik was really built to consume tabular data. So when connecting to...