topic Re: how to display top 5 values by using of rank function in QlikView

how to display top 5 values by using of rank function

Anonymous — Wed, 05 Nov 2014 09:52:25 GMT

Hi..

How to display top 5 values by using of rank function

MK_QSL — Wed, 05 Nov 2014 09:58:38 GMT

Considering that you have customer and sales data and you want top 5 customers by sales

Create a Straight Table

Use Calculated Dimension

=IF(Aggr(Rank(SUM(Sales),4),Customer)<=5,Customer)

Expression

SUM(Sales)

Use Below in your script:

Load * Inline

[

Customer, Sales

A, 100

B, 120

C, 300

D, 400

E, 75

F, 50

G, 125

H, 2000

I, 250

];

MK_QSL — Wed, 05 Nov 2014 10:04:48 GMT

Another Way

Create a Straight Table

Dimension

Customer

Expression

SUM({<Customer = {"=Rank(SUM(Sales),4)<=5"}>}Sales)

balanandam — Wed, 03 Jan 2018 10:29:28 GMT

I did as suggested. But my problem now is, it is taking top 5 as 100% rather than whole, and dividing them as per the share.

ex:

I need each one of the exact share(%) in the whole sum i.e, SUM(Sales).

Br, Balanandam