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...
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...
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. Example: Source In my opinion, the biggest benefit of using this is code readability. There may be times where...
We all use Qlik Community as a resource. If you don’t, it’d be a lot cooler if you did… I was a long time lurker, however recently in the past year I’ve started to contribute. And I gotta say, it has been a blast. I highly recommend contributing. It may not be...
This is a cool little trick that I use a lot because of preference. The idea is that you can rename all the fields within your Qlik application using one statement, two if you count prep work. Script: Source Result: Documentation I tend to use this so that the fields...
Qlik has great documentation, however it is a bit cumbersome when it talks about networking. Below are the ports needed. Also, you need to create an inbound and outbound rule. Here is a tutorial. It is much less complicated than it sounds. Ps. I am not covering HTTP...
