Challenge: Aggregate a Pareto result from an expression

onebot88 — Thu, 18 Feb 2016 10:04:35 GMT

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:

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

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,

Re: Challenge: Aggregate a Pareto result from an expression

Gysbert_Wassenaar — Thu, 18 Feb 2016 17:39:18 GMT

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

Re: Challenge: Aggregate a Pareto result from an expression

onebot88 — Fri, 19 Feb 2016 07:36:23 GMT

Good morning Gysbert,

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

Thanks so much,

topic Re: Challenge: Aggregate a Pareto result from an expression in QlikView

Challenge: Aggregate a Pareto result from an expression

Re: Challenge: Aggregate a Pareto result from an expression

Re: Challenge: Aggregate a Pareto result from an expression