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 […]
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 […]
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 […]
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 […]
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...
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 […]
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(),'...
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 […]
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, […]
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: […]