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: Caveat: Now when I think of the data type...
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...
You’d probably be surprised that this is one of my most used functions within a dashboard. It is just such a cool function. Though, it is almost exclusively used for UI/UX functionality. Only() “Only” is an aggregation function that can be used on a...
I am a firm believer that boiling down a problem into its simplest form is the fastest way to solving it. I also think one of the fundamentals of programming is breaking a problem into a bunch of smaller problems. If you combine these together, you get test cases out...
While it is great that Qlik offers a free desktop, I usually suggest trying to set up a server environment for local development. I personally run a Windows Server virtual machine (VM) with QSE installed, which I can access with my browser. I do it this way for three...
In other words, user defined functions. With utilizing variable parameters, you can create your own functions touse later. For example, a function to calculate the number of weeks between two date fields: SET fWeekDiff = '(((Year($2)*52)+Week($2))) -...
