topic Re: Add a rank column to straight table in QlikView

Add a rank column to straight table

Tue, 02 Dec 2014 17:55:20 GMT

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!

Re: Add a rank column to straight table

fsimoes81 — Tue, 02 Dec 2014 18:05:31 GMT

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

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

Re: Add a rank column to straight table

Tue, 02 Dec 2014 18:13:58 GMT

I tried that too but still same result

Re: Add a rank column to straight table

fsimoes81 — Tue, 02 Dec 2014 18:19:21 GMT

Are you have a example (qvw)?

Please, if possible, send a reduced qvw.

Re: Add a rank column to straight table

Tue, 02 Dec 2014 22:59:39 GMT

I got it to work, thank you