Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Rank | Customer | Sales |
1 | a | 10 |
2 | b | 9 |
3 | c | 8 |
4 | de | 7 |
5 | fg | 6 |
6 | Others | 10 |
Total | 50 |
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
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
try using dimension limits .
Else, please attach the qvw document.
Use Dimension Limits, that´s why they´re were made
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
please look at file I have attach
thanks this is what I was looking for !!!
no attachment
not working ? or you cant open ?