topic Rank as an expression within dimensions in QlikView

Rank as an expression within dimensions

Wed, 10 Apr 2013 18:47:44 GMT

Hi,

I have been search the forum for a few days on the Rank function and have not come across anything similar to my scenario.

I need to rank a dimension (Item #) within a second dimension (Store #) by an expression (sum(Qty)). I know I will need to use an aggr to group within the Store # dimension, but have not been able to come up with the right syntax to get to my result.

Here is where I started: aggr(rank(sum({$<Year={$(=max(Year))}>}QTY), 0, 1), ITEM#, STORE#) (not working)

Here is my desired result:

Please help if you can!

Thank you,

Nicole

Re: Rank as an expression within dimensions

ceciliafujita — Wed, 17 Sep 2014 18:50:53 GMT

Hi Nicole,

I'm have the same problem. Did you solve yours?

Re: Rank as an expression within dimensions

ceciliafujita — Wed, 17 Sep 2014 19:10:00 GMT

Hi Nicole, i solved: AGGR(NODISTINCT(RANK( $(yourMetric)_or_Formula())), DIM1, DIM2)