# New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Not applicable

## Total for largest 30 values

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.

Tags (2)
1 Solution

Accepted Solutions
Not applicable

## Total for largest 30 values

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))

4 Replies
Not applicable

## Total for largest 30 values

you can have a look at RANK function.

Regards,  tresesco

Not applicable

## Total for largest 30 values

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.

Not applicable

## Total for largest 30 values

Hi paulina6735

You can get this by using this expression

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

Celambarasan

Not applicable

## Total for largest 30 values

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))

Community Browser