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 clear in what […]

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 take you 40 YEARS to see the […]

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 “$(vAnswer)” in the below example. It is going to be expanded by […]

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 files it is trying […]

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(Floor((Rand()*10)/2)+1,'A','B','C','D','E') as Customer,     'Q'&(Mod(RowNo(), 4)+1) as Quarter,     Ceil((Rand() * 100) * (Rand()*10)) as Sales AutoGenerate &n...

87 – Qlik Community

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 pertinent to your […]

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    'Test' as DATA_NAME,    Rand() as RANDOM_NUMBER AutoGenerate    (100); FieldName_map: Mapping Load    FieldName(IterNo(),'Data') as OldName,    Capitalize(Replace(FieldName(IterNo(),'...

89 – Qlik Sense Ports

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 because you shouldn’t do it. Period. Single […]

90 – Dual Data Type Caveat

Dual combines a number and a string into a single record, such that the number representation of the record can be used for sorting and calculation purposes, while the string value can be used for display purposes. Syntax: Dual(text, number) Caveat Now when I think of the data type combining both text and a number value, […]

91 – Join Distinct

This is something that I found out the hard way. Qlik applies the DISTINCT keyword on the resulting dataset. So when you join distinct table, you are not joining the distinct table to the other table. You are doing the join and then returning the distinct records from the resulting join. Take this example: Original: […]