topic Trying to create a ranking table in QlikView

Trying to create a ranking table

tom906123 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am trying to create a ranking table based on sum(sales)

I am trying to achieve something like the below then graph the result

I am trying aggr(rank(sum(sales)),[customer],[month]) but no luck

My data looks something like this:

Any help would be much appreciated!

Thanks in advance!

sunny_talwar — Tue, 02 Oct 2018 14:25:05 GMT

Have you tried this already?

Dimension

Customer

month (Pivoted)

Expression

Rank(Sum(Sales))

tom906123 — Wed, 03 Oct 2018 13:22:46 GMT

Hi Sunny,

Thanks for your response.

I tried using the suggested pivot table with the below

1st Dimension: Customer

2nd Dimension: Month

Expression: ranks(sum(sales))

The result shows the below ranking the customer against their self

I would be really interested in see the customers rank against the entire population - any tips?

sunny_talwar — Wed, 03 Oct 2018 13:24:19 GMT

Drag the Month dimension to go across and see if that helps