Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Ranking Calculation in QlikView

I have the following data in a straight table:

Screen Shot 2015-11-08 at 13.04.49.png

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.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe just use expressions like

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

View solution in original post

3 Replies
swuehl
MVP
MVP

Maybe just use expressions like

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

Anonymous
Not applicable
Author

Thank you Swuehl, this works well

psankepalli
Partner - Creator III
Partner - Creator III

Thank you Swuehl, This explains well on Rank Function