Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Rankings Help

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

7 Replies
Not applicable

Re: Rankings Help

try using dimension limits .

Else, please attach the qvw document.

Employee
Employee

Re: Rankings Help

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

Not applicable

Re: Rankings Help

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
Contributor III

Re: Rankings Help

please look at file I have attach

Not applicable

Re: Rankings Help

thanks this is what I was looking for !!!

Not applicable

Re: Rankings Help


no attachment

annafuksa1
Contributor III

Re: Rankings Help

not working ? or you cant open ?

Community Browser