topic Sorting within a Rank function in QlikView https://community.qlik.com/t5/QlikView/Sorting-within-a-Rank-function/m-p/521887#M551678 <HTML><HEAD></HEAD><BODY><P>I am trying to obtain the top 25% of members in a given org.&nbsp; My issue is that around the cut-offs there are ties.&nbsp; With the Rank(Field, 4) I am able to get the right number of members but the wrong members that make up those numbers.&nbsp; In a table box I can sort by the Rank first and then by the members ID number.&nbsp; The issue is I am trying to use this expression in a text object so I am not able to use the sort tab. </P><P></P><P>Is there a way to Sort by Rank and then ID number within a text object.&nbsp; I have already tried an Order By IDNumber ASC in the script and it didn't seem to make any difference.</P></BODY></HTML> Thu, 24 Oct 2013 16:26:49 GMT jpapador 2013-10-24T16:26:49Z Sorting within a Rank function https://community.qlik.com/t5/QlikView/Sorting-within-a-Rank-function/m-p/521887#M551678 <HTML><HEAD></HEAD><BODY><P>I am trying to obtain the top 25% of members in a given org.&nbsp; My issue is that around the cut-offs there are ties.&nbsp; With the Rank(Field, 4) I am able to get the right number of members but the wrong members that make up those numbers.&nbsp; In a table box I can sort by the Rank first and then by the members ID number.&nbsp; The issue is I am trying to use this expression in a text object so I am not able to use the sort tab. </P><P></P><P>Is there a way to Sort by Rank and then ID number within a text object.&nbsp; I have already tried an Order By IDNumber ASC in the script and it didn't seem to make any difference.</P></BODY></HTML> Thu, 24 Oct 2013 16:26:49 GMT https://community.qlik.com/t5/QlikView/Sorting-within-a-Rank-function/m-p/521887#M551678 jpapador 2013-10-24T16:26:49Z Re: Sorting within a Rank function https://community.qlik.com/t5/QlikView/Sorting-within-a-Rank-function/m-p/521888#M551679 <HTML><HEAD></HEAD><BODY><P>Use the ID number to create a fraction that can be added to the value you now rank on. </P><P>Maybe something like rank(Field+ IDNumber/100000,4)</P></BODY></HTML> Thu, 24 Oct 2013 16:50:54 GMT https://community.qlik.com/t5/QlikView/Sorting-within-a-Rank-function/m-p/521888#M551679 Gysbert_Wassenaar 2013-10-24T16:50:54Z