topic Tie Breaker in Rank Function in QlikView https://community.qlik.com/t5/QlikView/Tie-Breaker-in-Rank-Function/m-p/1157385#M629935 <HTML><HEAD></HEAD><BODY><P>I'm currently using this formula to rank counts.</P><P></P><P>=rank(count(FacilityAccountID),0,1)</P><P></P><P>However, I'm getting the result below.<IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/134081_Capture.JPG" style="height: 230px; width: 620px;" /></P><P></P><P>How do I break the ties in the Rank number column? Is there another field that can be used to break the tie?</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 09 Aug 2016 15:07:17 GMT trmcbrad 2016-08-09T15:07:17Z Tie Breaker in Rank Function https://community.qlik.com/t5/QlikView/Tie-Breaker-in-Rank-Function/m-p/1157385#M629935 <HTML><HEAD></HEAD><BODY><P>I'm currently using this formula to rank counts.</P><P></P><P>=rank(count(FacilityAccountID),0,1)</P><P></P><P>However, I'm getting the result below.<IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/134081_Capture.JPG" style="height: 230px; width: 620px;" /></P><P></P><P>How do I break the ties in the Rank number column? Is there another field that can be used to break the tie?</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 09 Aug 2016 15:07:17 GMT https://community.qlik.com/t5/QlikView/Tie-Breaker-in-Rank-Function/m-p/1157385#M629935 trmcbrad 2016-08-09T15:07:17Z Re: Tie Breaker in Rank Function https://community.qlik.com/t5/QlikView/Tie-Breaker-in-Rank-Function/m-p/1157386#M629936 <HTML><HEAD></HEAD><BODY><P>Try this may be:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=Num(Rank(Count(FacilityAccountID),4,1))</STRONG></SPAN></P></BODY></HTML> Tue, 09 Aug 2016 16:03:43 GMT https://community.qlik.com/t5/QlikView/Tie-Breaker-in-Rank-Function/m-p/1157386#M629936 sunny_talwar 2016-08-09T16:03:43Z Re: Tie Breaker in Rank Function https://community.qlik.com/t5/QlikView/Tie-Breaker-in-Rank-Function/m-p/1157387#M629937 <HTML><HEAD></HEAD><BODY><P>Thank you so much for your help!!!!!!!</P></BODY></HTML> Tue, 09 Aug 2016 16:07:34 GMT https://community.qlik.com/t5/QlikView/Tie-Breaker-in-Rank-Function/m-p/1157387#M629937 trmcbrad 2016-08-09T16:07:34Z