Discussion Board for collaboration on QlikView Scripting.
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)
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.
Go to Solution.
You can also create a Calculated Dimension:
=Aggr(If(Rank(Sum([Sales]))<5, FABRICANT_LName, 'Others'), FABRICANT_LName)
Your expression will be Sum(Sales)
try using dimension limits .
Else, please attach the qvw document.
Use Dimension Limits, that´s why they´re were made
please look at file I have attach
thanks this is what I was looking for !!!
not working ? or you cant open ?