topic Total for largest 30 values in QlikView

Total for largest 30 values

Tue, 24 Jan 2012 08:33:22 GMT

Hi,

I have a bar chart with top 30 people with highest number of meetings. I'm trying to add text to chart with the information about total number of meetings for them, but I don't know how to calculate such thing. What is the easiest way to calculate sum of totals for top 30? Please help, thanks in advance.

Total for largest 30 values

tresB — Tue, 24 Jan 2012 08:41:59 GMT

you can have a look at RANK function.

Regards, tresesco

Total for largest 30 values

Tue, 24 Jan 2012 08:45:36 GMT

I've tried to use it, but I don't know how should the whole expression for this look like, not only for rank function, but for totals that are for people ranked 1-30.

Total for largest 30 values

CELAMBARASAN — Tue, 24 Jan 2012 08:47:09 GMT

Hi paulina6735

You can get this by using this expression

=Sum({<PeopleID={"=(Rank(Sum(Meetings))<=30)"}>}Aggr(Sum(Meetings),PeopleID))

Celambarasan

Total for largest 30 values

Tue, 24 Jan 2012 09:26:39 GMT

Thanks, it didn't worked for me - maybe I did something wrong...

I looked for other solution and inspired by this topic: http://community.qlik.com/message/48857#48857 I wrote the expression which works perfect:

sum(aggr(if(rank(count(PeopleID))<=30,count(PeopleID)), PeopleID))