Ranking Calculation in QlikView

[Anonymous]

I have the following data in a straight table:

I need to be able to calculate 2012 and 2013 rankings based on the '2012 Quantity' and '2013 Quantity'.  How can this be accomplished in QlikView?  Please see attached sample application.

Regards.

[swuehl · Accepted solution]

Maybe just use expressions like

=Rank(TOTAL Sum ({$<Year={2012},Month=>} QTY))

[Anonymous]

Thank you Swuehl, this works well

[psankepalli]

Thank you Swuehl, This explains well on Rank Function