topic Rank in Text Box in QlikView https://community.qlik.com/t5/QlikView/Rank-in-Text-Box/m-p/253437#M96042 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>How can I display the rank&nbsp; in a text box&nbsp;&nbsp; of a selected value&nbsp; from a list box ?</P><P></P><P>Suppose I have this input data</P><P>Id&nbsp;&nbsp; Value</P><P>1&nbsp;&nbsp;&nbsp; 100</P><P>2&nbsp;&nbsp;&nbsp; 10</P><P>3&nbsp;&nbsp;&nbsp; 500</P><P></P><P></P><P>If I selectec&nbsp;&nbsp; Id=1&nbsp; I&nbsp;&nbsp; want to display in the text box Rank = 2</P><P></P><P>Regards</P><P>JJ</P></BODY></HTML> Sat, 04 Feb 2012 19:13:29 GMT 2012-02-04T19:13:29Z Rank in Text Box https://community.qlik.com/t5/QlikView/Rank-in-Text-Box/m-p/253437#M96042 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>How can I display the rank&nbsp; in a text box&nbsp;&nbsp; of a selected value&nbsp; from a list box ?</P><P></P><P>Suppose I have this input data</P><P>Id&nbsp;&nbsp; Value</P><P>1&nbsp;&nbsp;&nbsp; 100</P><P>2&nbsp;&nbsp;&nbsp; 10</P><P>3&nbsp;&nbsp;&nbsp; 500</P><P></P><P></P><P>If I selectec&nbsp;&nbsp; Id=1&nbsp; I&nbsp;&nbsp; want to display in the text box Rank = 2</P><P></P><P>Regards</P><P>JJ</P></BODY></HTML> Sat, 04 Feb 2012 19:13:29 GMT https://community.qlik.com/t5/QlikView/Rank-in-Text-Box/m-p/253437#M96042 2012-02-04T19:13:29Z Rank in Text Box https://community.qlik.com/t5/QlikView/Rank-in-Text-Box/m-p/253438#M96043 <HTML><HEAD></HEAD><BODY><P>Try</P><P>= 'Rank = ' &amp; aggr( if(d=GetFieldSelections(Id),rank(sum({1} Value))),Id)</P></BODY></HTML> Sun, 05 Feb 2012 00:15:26 GMT https://community.qlik.com/t5/QlikView/Rank-in-Text-Box/m-p/253438#M96043 swuehl 2012-02-05T00:15:26Z Rank in Text Box https://community.qlik.com/t5/QlikView/Rank-in-Text-Box/m-p/253439#M96044 <HTML><HEAD></HEAD><BODY><P>Thanks Stefan</P><P></P><P>It works also without the GetFieldSelection :</P><P>= aggr(&nbsp; rank(sum({1} V)),Id)</P><P>JJ</P></BODY></HTML> Sun, 05 Feb 2012 09:10:10 GMT https://community.qlik.com/t5/QlikView/Rank-in-Text-Box/m-p/253439#M96044 2012-02-05T09:10:10Z