Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Add a rank column to straight table

Hi I want to add a column to rank the accounts by Total Units. I sorted by Total Units and added the Rank expression but is not displaying as I am expecting it to. I would like to see Account E listed as 1, Account C listed as 2, Account D listed as 3 and so on.

I use this as the expression =rank([Total Units]) but only returning 1s

Total Units is Sum({CalendaryYear = {$=max(CalendarYear)}>} QuantityShipped)

Please help, thank you in advance!

2014-12-02_9-48-19.png

4 Replies
fsimoes81
Partner - Contributor III
Partner - Contributor III

It's strange, rank([Total Units]) it should work.

Try Rank(Sum({CalendaryYear = {$=max(CalendarYear)}>} QuantityShipped))

Not applicable
Author

I tried that too but still same result

fsimoes81
Partner - Contributor III
Partner - Contributor III

Are you have a example (qvw)?

Please, if possible, send a reduced qvw.

Not applicable
Author

I got it to work, thank you