topic Re: Simple Rank expression in QlikView https://community.qlik.com/t5/QlikView/Simple-Rank-expression/m-p/685416#M1067926 <HTML><HEAD></HEAD><BODY><P>That's correct. Thank you very much for your valuable time.</P></BODY></HTML> Mon, 01 Sep 2014 14:08:10 GMT 2014-09-01T14:08:10Z Simple Rank expression https://community.qlik.com/t5/QlikView/Simple-Rank-expression/m-p/685414#M1067924 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I need an expression that returns the following ranking :</P><P></P><P>I have successfully calculated the following simple average:</P><P></P><P> <STRONG>Avg( {$&lt;Category={1}&gt;} Amount )</STRONG></P><P></P><P>and I have another dimension "Country" in a Multi box and whenever I make a choise, the above average is obviously calculated for the selected country.</P><P></P><P>What I need is an expression that calculates the ranking of the selected country of this average for this category=1 . Can anyone help me on this please ?? </P></BODY></HTML> Mon, 01 Sep 2014 13:46:20 GMT https://community.qlik.com/t5/QlikView/Simple-Rank-expression/m-p/685414#M1067924 2014-09-01T13:46:20Z Re: Simple Rank expression https://community.qlik.com/t5/QlikView/Simple-Rank-expression/m-p/685415#M1067925 <HTML><HEAD></HEAD><BODY><P><STRONG>=Aggr(Rank(Avg({&lt;Category={1}, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Country</SPAN>= &gt;}Amount)),<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Country</SPAN>)</STRONG></P></BODY></HTML> Mon, 01 Sep 2014 13:59:51 GMT https://community.qlik.com/t5/QlikView/Simple-Rank-expression/m-p/685415#M1067925 MK_QSL 2014-09-01T13:59:51Z Re: Simple Rank expression https://community.qlik.com/t5/QlikView/Simple-Rank-expression/m-p/685416#M1067926 <HTML><HEAD></HEAD><BODY><P>That's correct. Thank you very much for your valuable time.</P></BODY></HTML> Mon, 01 Sep 2014 14:08:10 GMT https://community.qlik.com/t5/QlikView/Simple-Rank-expression/m-p/685416#M1067926 2014-09-01T14:08:10Z