aggr top 100

[sr_qlikview]

i have a expression like

AVG( aggr(sum(sales),Client))

i want to get only top 100 clients based on sum(sales)

how to control data with in aggr set ?

[MayilVahanan]

Hi

Use dimension limit or rank() function.

Hope it helps

[Sokkorn]

Hi sr_qlikview,

It can be done via:

1. Use Dimension Limit

2. Sum({$<Client = {"=Rank(Aggr(Sum(Sales),Client))<= 100"}>}Sales)

Regards,

Sokkorn

[#4]

try this

take dimension---  client

                           sales

Expression--      aggr(if(rank(sum(sales))<=100,client),client)

Then output comes fine.

[#5]

example

LOAD * INLINE [

    client, sales

    a, 10

    b, 30

    c, 20

    d, 5

    e, 40

];

Dimension-- client

                  sales

expression--   aggr(if(rank(sum(sales))<3,client),client)

Then output comes like this

client	sales	Top two client
b	30	b
e	40	e

[narender123]

Hi,

1)In dimention limit select  show only box select * largest

                                                             * 100

2)In expression tab select Sum of rows

Thanks.

Narender