Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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 ?