This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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?
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)))
View solution in original post
Thank you Sunny,
We are close, but I still get the "allocated memory exceeded" issue in the document you attached,.
Which version of QlikView are you using?
The syntax I used is only available in QlikView 12.1 or above
Recipe for a Pareto Analysis – Revisited
I am using version 11.2. Do you know if there is any possible syntax for this version?
It's not nice, but take a look here
ABC Analysis in Qlikview