topic Recipe for a Pareto Analysis in QlikView

Recipe for a Pareto Analysis

Anonymous — Fri, 01 Jul 2016 07:32:44 GMT

First thank you so much hic‌ for this post. Now we have below requirement. How can we get it done (attached QVW)?

-Heap

Re: Recipe for a Pareto Analysis

Anonymous — Sat, 02 Jul 2016 12:18:44 GMT

Any idea pls

Re: Recipe for a Pareto Analysis

sunny_talwar — Sat, 02 Jul 2016 15:47:40 GMT

May be this:

Avg

=Num(Avg({<ProductName = {"=RangeSum(Above(Sum(Sales), 1, RowNo())) / Sum(total Sales) <= 0.80"}>} Sales), '#,##0')

Min

=Num(Min({<ProductName = {"=RangeSum(Above(Sum(Sales), 1, RowNo())) / Sum(total Sales) <= 0.80"}>} Sales), '#,##0')

Re: Recipe for a Pareto Analysis

Anonymous — Mon, 04 Jul 2016 02:30:26 GMT

Hi Sunny,

When used in real data set, it return wrong number. Any idea in new attached file?

Heap

Re: Recipe for a Pareto Analysis

sunny_talwar — Mon, 04 Jul 2016 19:59:17 GMT

The problem here is that there is no way to sort using an expression within the Aggregate function. I think we need expert advice here from swuehl‌‌‌ gwassenaar‌‌ marcowedel‌‌‌ johnw‌

Re: Recipe for a Pareto Analysis

Anonymous — Tue, 05 Jul 2016 02:06:45 GMT

Hi Sunny. It's OK if we cannot get average into text box. See below reference line (3 red lines) in scatter chart are manual input number. Can you suggest if it is do-able with dynamic expression in attached QVW file?

Heap

Re: Recipe for a Pareto Analysis

Gysbert_Wassenaar — Tue, 05 Jul 2016 07:21:13 GMT

You need two things for this:

1. A table with total sales values per product

2. Qlikview 12 or Qlik Sense so you can make use of the new sorting feature of the aggr function.

I don't have Qlikview 12 at hand right now, so I created an example in Qlik Sense in Qlik Cloud. I've attached the app here. If you don't have Qlik Sense you can upload it to Qlik Cloud (register for free if necessary) and then have a look at the expressions in the app.

Re: Recipe for a Pareto Analysis

Anil_Babu_Samineni — Tue, 05 Jul 2016 07:59:14 GMT

Heap,

I need to ask you before moving

1) Pareto Class - Before expression you have % with two digits and current expression your limitations showing 0.8%

- Anil

Re: Recipe for a Pareto Analysis

Anonymous — Tue, 05 Jul 2016 08:32:19 GMT

Hi Gysbert,

Thank you so much for suggestion. For the moment, we only consider upgrade to QlikView 12.

to stay with Qlik

Heap

Re: Recipe for a Pareto Analysis

Anonymous — Tue, 05 Jul 2016 08:35:52 GMT

Hi Anil,

I did not get your point. By the way, I confirm that class A,B,C shown below is what I want. The only thing left is get average each class into text object. Any idea?

Heap