topic Rank by Dimension in QlikView https://community.qlik.com/t5/QlikView/Rank-by-Dimension/m-p/362828#M494861 <HTML><HEAD></HEAD><BODY><P>This is a pretty straight-forward question, but after failing to find a Discussion about it I thought I'd create one. Thank you for your help in advance.</P><P></P><P>I have a Pivot Chart that has 3 Dimensions: 1) Retail Region Number&nbsp;&nbsp; 2) Store Number&nbsp;&nbsp; 3) Store Name</P><P>There is also a bunch of expressions, the one I'm trying to sort by is entitled [TY In-Store NS $]</P><P></P><P>I want to rank each Store Number within each Retail Region Number. So if there are 12 stores in each region, then I would expect to see three rankings of 1 through 12. Right now I have the below syntax and it Ranks by Store Number, and ignores the Region.</P><P></P><P>RANK(TOTAL [TY In-Store NS $],0,1)</P><P></P><P></P><P>Thank you,</P><P>-Michael</P></BODY></HTML> Wed, 21 Mar 2012 14:10:13 GMT 2012-03-21T14:10:13Z Rank by Dimension https://community.qlik.com/t5/QlikView/Rank-by-Dimension/m-p/362828#M494861 <HTML><HEAD></HEAD><BODY><P>This is a pretty straight-forward question, but after failing to find a Discussion about it I thought I'd create one. Thank you for your help in advance.</P><P></P><P>I have a Pivot Chart that has 3 Dimensions: 1) Retail Region Number&nbsp;&nbsp; 2) Store Number&nbsp;&nbsp; 3) Store Name</P><P>There is also a bunch of expressions, the one I'm trying to sort by is entitled [TY In-Store NS $]</P><P></P><P>I want to rank each Store Number within each Retail Region Number. So if there are 12 stores in each region, then I would expect to see three rankings of 1 through 12. Right now I have the below syntax and it Ranks by Store Number, and ignores the Region.</P><P></P><P>RANK(TOTAL [TY In-Store NS $],0,1)</P><P></P><P></P><P>Thank you,</P><P>-Michael</P></BODY></HTML> Wed, 21 Mar 2012 14:10:13 GMT https://community.qlik.com/t5/QlikView/Rank-by-Dimension/m-p/362828#M494861 2012-03-21T14:10:13Z Re: Rank by Dimension https://community.qlik.com/t5/QlikView/Rank-by-Dimension/m-p/362829#M494862 <HTML><HEAD></HEAD><BODY><P>=if(aggr(</P><P>rank(sum(value)),Dimension_1,Dimension_2)&lt;=4,</P><P>aggr(rank(sum(value)),Dimension_1,Dimension_2))</P></BODY></HTML> Mon, 22 Jan 2018 07:00:47 GMT https://community.qlik.com/t5/QlikView/Rank-by-Dimension/m-p/362829#M494862 Anonymous 2018-01-22T07:00:47Z