topic Re: Rank - Break tie? in QlikView https://community.qlik.com/t5/QlikView/Rank-Break-tie/m-p/380777#M491364 <HTML><HEAD></HEAD><BODY><P>This is a couple years old, but there is a <EM>format</EM> parameter to the rank function which gives you the ability to specify how you would like a tie broken.</P><P></P><P>rank( expression, 0, 1) for example would take the lowest rank.</P><P></P><P>See the QV reference manual on page 822 for more info.</P></BODY></HTML> Mon, 18 Aug 2014 17:02:23 GMT bdiamante 2014-08-18T17:02:23Z Rank - Break tie? https://community.qlik.com/t5/QlikView/Rank-Break-tie/m-p/380776#M491363 <HTML><HEAD></HEAD><BODY><P>Hello, I'm currently using the Rank function to get the top 1 of some values on my table. After playing with the data, somethimes i got "four #1" (appears like 1-4 in the rank position). Is there anyway to break this tie (alphabetically,decimals, etc)?</P><P></P><P>thanks in advance</P></BODY></HTML> Fri, 24 Aug 2012 16:00:24 GMT https://community.qlik.com/t5/QlikView/Rank-Break-tie/m-p/380776#M491363 2012-08-24T16:00:24Z Re: Rank - Break tie? https://community.qlik.com/t5/QlikView/Rank-Break-tie/m-p/380777#M491364 <HTML><HEAD></HEAD><BODY><P>This is a couple years old, but there is a <EM>format</EM> parameter to the rank function which gives you the ability to specify how you would like a tie broken.</P><P></P><P>rank( expression, 0, 1) for example would take the lowest rank.</P><P></P><P>See the QV reference manual on page 822 for more info.</P></BODY></HTML> Mon, 18 Aug 2014 17:02:23 GMT https://community.qlik.com/t5/QlikView/Rank-Break-tie/m-p/380777#M491364 bdiamante 2014-08-18T17:02:23Z