topic Max Rank Display in QlikView

Max Rank Display

Anonymous — Mon, 17 Aug 2015 09:03:21 GMT

Hello,

I am attempting to display the ranking of sales per user.

Then I will later want to compare their sales figures to other users.

Please could someone explain how to rank the sales figures, to see the top 3 Users. Then display the top sales figures, so that we can later have a comparison to other Users and the top User, see attachment.

Thank you.

Re: Max Rank Display

lironbaram — Mon, 17 Aug 2015 09:59:09 GMT

have a look at the attach example

hope it helps you

Re: Max Rank Display

MK_QSL — Mon, 17 Aug 2015 10:02:19 GMT

Create a Straight Table

Dimension

User

Expression

SUM(Sales)

Num(Rank(SUM(Sales),4))

SUM(TOTAL {<User = {"=Rank(SUM(Sales),4)=1"}>}Sales)

If you want to compare top 3 with top then use as below

Straight Table

Dimension

User

Expression

SUM({<User = {"=Rank(SUM(Sales),4)<=3"}>}Sales)

NUM(Rank(SUM({<User = {"=Rank(SUM(Sales),4)<=3"}>}Sales),4))

SUM(TOTAL {<User = {"=Rank(SUM(Sales),4)=1"}>}Sales)