Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Rank by Dimension

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.

I have a Pivot Chart that has 3 Dimensions: 1) Retail Region Number   2) Store Number   3) Store Name

There is also a bunch of expressions, the one I'm trying to sort by is entitled [TY In-Store NS $]

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.

RANK(TOTAL [TY In-Store NS $],0,1)

Thank you,

-Michael

1 Reply
rubandoss786
Contributor

Re: Rank by Dimension

=if(aggr(

rank(sum(value)),Dimension_1,Dimension_2)<=4,

aggr(rank(sum(value)),Dimension_1,Dimension_2))