Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
onebot88
Partner - Contributor II
Partner - Contributor II

Challenge: Aggregate a Pareto result from an expression

Good morning to everyone from Barcelona.

I’ve been working with Qlikview for several months and I’ve been doing well until I faced with this issue.

My question is: Is it possible to make an aggr from a result expression?

Let me explain, I’ve got a table like this:

Pareto_example.PNG

And I’d like to obtain an output like this:

data.PNG

The problem I’m facing is that I found no way to make an aggr from an expression. If you take a look at the qvw attached you’ll see that in the last expression I classify the different customers into their respective group of % (label: Pareto).

Is it possible to group them from that expression into what I’m trying to accomplish?

By the way, the post where I got the information about Pareto is: Qlik Design Blog : Recipe for a Pareto Analysis | Qlik Community

Thank you for your time; I’m still newbie at this.

Regards,

2 Replies
Gysbert_Wassenaar

There's no nice and easy way to do this. For the not so easy solution see this discussion: number of customer who makes 80% of turnover


talk is cheap, supply exceeds demand
onebot88
Partner - Contributor II
Partner - Contributor II
Author

Good morning Gysbert,

That's an approach I didn't tried yet.

Thanks so much,