How can I group a dimension by percentage in a pivot table?

[Anonymous]

I am trying in a pivot table (two dimensiones: passengers as rows and Company as colums) to display at a total level the top passengers that reach 80% of tickets.

The other passengers that are not inside the top 80% should appear grouped as as Others.

I am trying with the following dimensions:

if (RangeSum(Above(Sum(Tickets),0,RowNo()))/sum(total Tickets)<'0,8',Passenger,'Otros')

However, I get the allocated memory exceede message.

Can anyone help me?

[sunny_talwar · Accepted solution]

Try this as your calculated dimension

=Aggr(If(RangeSum(Above(Sum(Tickets),0,RowNo()))/Sum(TOTAL <Company> Tickets) < '0,8', Passenger,'Otros'), Company, (Passenger, (=Sum(Tickets), DESC)))

[Anonymous]

Thank you Sunny,

We are close, but I still get the "allocated memory exceeded" issue in the document you attached,.

[sunny_talwar]

Which version of QlikView are you using?

[sunny_talwar]

The syntax I used is only available in QlikView 12.1 or above

Recipe for a Pareto Analysis – Revisited

[Anonymous]

Thank you Sunny,

I am using version 11.2. Do you know if there is any possible syntax for this version?

[sunny_talwar]

It's not nice, but take a look here

ABC Analysis in Qlikview