Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rankings Help

I am trying to create rankings i.e Top 25, Top 30 based annual sales with-in variance groupings i.e products, industry, etc....

However,  the trick is getting the remaining customers as cumulative sub-total within the total (see table below)

RankCustomer Sales
1a10
2b9
3c8
4de7
5fg6
6Others10
Total50

I can create this in excel, I have created the result set within an sql if using oracle just cant get the aggregate function in Qlikview.

Any help is greatly appreciated.

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

You can also create a Calculated Dimension:

=Aggr(If(Rank(Sum([Sales]))<5, FABRICANT_LName, 'Others'),  FABRICANT_LName)

Your expression will be Sum(Sales)

Fabrice

View solution in original post

7 Replies
Not applicable
Author

try using dimension limits .

Else, please attach the qvw document.

Clever_Anjos
Employee
Employee

Use Dimension Limits, that´s why they´re were made

Not applicable
Author

Hi,

You can also create a Calculated Dimension:

=Aggr(If(Rank(Sum([Sales]))<5, FABRICANT_LName, 'Others'),  FABRICANT_LName)

Your expression will be Sum(Sales)

Fabrice

annafuksa1
Creator III
Creator III

please look at file I have attach

Not applicable
Author

thanks this is what I was looking for !!!

Not applicable
Author


no attachment

annafuksa1
Creator III
Creator III

not working ? or you cant open ?