89 – Qlik Sense Ports

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...
90 – Dual Data Type Caveat

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: Caveat: Now when I think of the data type...
91 – Join Distinct

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...
89 – Qlik Sense Ports

92 – Only

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...