Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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
Hi @Rodj , thanks for the reply.
No, I am using the native limitation controls in the Qlik interface.
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.