Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
landerliz
Contributor II
Contributor II

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

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?

1 Solution

Accepted Solutions
sunny_talwar

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)))

Capture.PNG

View solution in original post

6 Replies
sunny_talwar

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)))

Capture.PNG

View solution in original post

landerliz
Contributor II
Contributor II
Author

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

landerliz
Contributor II
Contributor II
Author

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