Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

trmcbrad
New Contributor

Tie Breaker in Rank Function

I'm currently using this formula to rank counts.

=rank(count(FacilityAccountID),0,1)

However, I'm getting the result below.Capture.JPG

How do I break the ties in the Rank number column? Is there another field that can be used to break the tie?

Thanks!

1 Solution

Accepted Solutions

Re: Tie Breaker in Rank Function

Try this may be:

=Num(Rank(Count(FacilityAccountID),4,1))

2 Replies

Re: Tie Breaker in Rank Function

Try this may be:

=Num(Rank(Count(FacilityAccountID),4,1))

trmcbrad
New Contributor

Re: Tie Breaker in Rank Function

Thank you so much for your help!!!!!!!

Community Browser