topic Re: Ranking within a dimension value in QlikView https://community.qlik.com/t5/QlikView/Ranking-within-a-dimension-value/m-p/562234#M556129 <HTML><HEAD></HEAD><BODY><P>hi avastani do you have a sample with the table for the 3 columns (sales, sales office , item) to think in something realistic</P></BODY></HTML> Thu, 09 Apr 2015 19:58:54 GMT hectorgarcia 2015-04-09T19:58:54Z Ranking within a dimension value https://community.qlik.com/t5/QlikView/Ranking-within-a-dimension-value/m-p/562233#M556128 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a unique situation with a pivot table where I would like to compute the rank not amongst the values displayed but among the family of underlying values that roll up to the value in the dimension. Is this possible with good performance?</P><P></P><P>For eg.</P><P></P><P>SaleOffice&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P>&nbsp;&nbsp;&nbsp;&nbsp; B1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150</P><P>&nbsp;&nbsp;&nbsp;&nbsp; B2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P></P><P>User will select an Item that is probably sold in multiple sales offices. We want to see what is the Rank of that product's sales for each SalesOffice and then underyling branches of the Office. So it may be that in office A the item had 25 in sales and hence rank 3 but in office B it had 145 in sales making it rank 1 for B but 80 in B1 giving rank 2 etc.</P><P></P><P>Looking for an efficient AGGR() with rank that doesn't take too much time.</P></BODY></HTML> Wed, 10 Jul 2013 17:08:54 GMT https://community.qlik.com/t5/QlikView/Ranking-within-a-dimension-value/m-p/562233#M556128 avastani 2013-07-10T17:08:54Z Re: Ranking within a dimension value https://community.qlik.com/t5/QlikView/Ranking-within-a-dimension-value/m-p/562234#M556129 <HTML><HEAD></HEAD><BODY><P>hi avastani do you have a sample with the table for the 3 columns (sales, sales office , item) to think in something realistic</P></BODY></HTML> Thu, 09 Apr 2015 19:58:54 GMT https://community.qlik.com/t5/QlikView/Ranking-within-a-dimension-value/m-p/562234#M556129 hectorgarcia 2015-04-09T19:58:54Z