topic Re: RANKING in QlikView https://community.qlik.com/t5/QlikView/RANKING/m-p/675605#M1057501 <HTML><HEAD></HEAD><BODY><P>Is this you need?</P></BODY></HTML> Tue, 07 Oct 2014 19:04:17 GMT ecolomer 2014-10-07T19:04:17Z RANKING https://community.qlik.com/t5/QlikView/RANKING/m-p/675603#M1057499 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Let's imagine we have two fields: Articles and Sales.</P><P></P><P><IMG alt="Ventas_Articles.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/68422_Ventas_Articles.png" /><IMG alt="tabla.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/68432_tabla.png" /></P><P><STRONG>The objective is to create a Text Object that says the rank position of each Article (in terms of Sales)</STRONG>, meaning that when we select the Article=A we want to see our text object saying:7 as is it shown into the right table. The current problem with the right table is that when we select one Article, the rank is always 1, no matter what article is selected.</P><P><IMG alt="taula2.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/68433_taula2.png" /></P><P>Thank you in advance!</P></BODY></HTML> Tue, 07 Oct 2014 16:48:30 GMT https://community.qlik.com/t5/QlikView/RANKING/m-p/675603#M1057499 2014-10-07T16:48:30Z Re: RANKING https://community.qlik.com/t5/QlikView/RANKING/m-p/675604#M1057500 <HTML><HEAD></HEAD><BODY><P>try</P><P>aggr(rank(sum({&lt;Article=&gt;} Ventas)), Article)</P></BODY></HTML> Tue, 07 Oct 2014 17:11:04 GMT https://community.qlik.com/t5/QlikView/RANKING/m-p/675604#M1057500 maxgro 2014-10-07T17:11:04Z Re: RANKING https://community.qlik.com/t5/QlikView/RANKING/m-p/675605#M1057501 <HTML><HEAD></HEAD><BODY><P>Is this you need?</P></BODY></HTML> Tue, 07 Oct 2014 19:04:17 GMT https://community.qlik.com/t5/QlikView/RANKING/m-p/675605#M1057501 ecolomer 2014-10-07T19:04:17Z Re: RANKING https://community.qlik.com/t5/QlikView/RANKING/m-p/675606#M1057502 <HTML><HEAD></HEAD><BODY><P>I've used set analysis in "Article" to ignore its selection.</P><P></P><P></P><P>Good luck!</P></BODY></HTML> Tue, 07 Oct 2014 19:36:15 GMT https://community.qlik.com/t5/QlikView/RANKING/m-p/675606#M1057502 2014-10-07T19:36:15Z Re: RANKING https://community.qlik.com/t5/QlikView/RANKING/m-p/675607#M1057503 <HTML><HEAD></HEAD><BODY><P>THANK YOU!</P></BODY></HTML> Wed, 08 Oct 2014 07:25:56 GMT https://community.qlik.com/t5/QlikView/RANKING/m-p/675607#M1057503 2014-10-08T07:25:56Z