Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jdean1012
Contributor III
Contributor III

Table Column Fixed Number Limitation TIE BREAKER

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

Qlik Sense Column Limitation TIES.PNG

Labels (3)
3 Replies
Rodj
Luminary Alumni
Luminary Alumni

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

jdean1012
Contributor III
Contributor III
Author

Hi @Rodj , thanks for the reply.

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

Qlik Sense Column Limitation Control.PNG

Rodj
Luminary Alumni
Luminary Alumni

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.