topic Re: Table Column Fixed Number Limitation TIE BREAKER in App Development

Table Column Fixed Number Limitation TIE BREAKER

jdean1012 — Sat, 16 Nov 2024 19:20:28 GMT

I have a table where I want to show the top 5, but there are ties. Qlik Sense still returns 5, but there is no discernible logic to how it breaks the tie for the 5th spot. See screenshot. Is there a way to configure this to show all ties, even if the top 5 actually ends up being a top 9 with the ties included? THANKS!!

Re: Table Column Fixed Number Limitation TIE BREAKER

Rodj — Wed, 08 Jan 2020 23:31:45 GMT

Hi @jdean1012 ,

I assume you are using the Rank function for this? Have you seen https://community.qlik.com/t5/QlikView-Scripting/Tie-Breaker-in-Rank-Function/m-p/1157385? It might point you in the right direction.

Cheers,

Rod

Re: Table Column Fixed Number Limitation TIE BREAKER

jdean1012 — Thu, 09 Jan 2020 13:50:59 GMT

Hi @Rodj , thanks for the reply.

No, I am using the native limitation controls in the Qlik interface.

Re: Table Column Fixed Number Limitation TIE BREAKER

Rodj — Thu, 09 Jan 2020 20:47:25 GMT

You could probably configure the limitation via the fixed value expression but I think you'd end up likely using the Rank function in that to get what you want, so it would be simpler to just use the Rank function which will give you more flexibility. Your measure would be something like:

if(rank([Non-compliant tickets],2) < 6, [Non-compliant tickets], null())

and uncheck Add-ons -> Data Handling -> include zero values.