topic IDENTIFY RULE 80/20 DYNAMICALLY UNDER A CHART in QlikView

IDENTIFY RULE 80/20 DYNAMICALLY UNDER A CHART

Fri, 28 Feb 2014 16:46:47 GMT

Hi all,

1. I've wrecking my head against the following. I've a table (chart type) that contains a cumulative frequency:

customer	sales
a	100
b	400
c	350
d	150
e	50

2. after ordering and get the cumulative frequency:

customer	sales	cum. Frequency	% cum.
b	400	400	38.10%
c	350	750	71.43%
d	150	900	85.71%
a	100	1000	95.24%
e	50	1050	100.00%

3. Well, what i want, is the sum of the products that makes the "80/20", in this case the sum of b,c but presented in a label.

Resulting label:

2 products which represent the 40% of total products makes the 85.71% of the sales (obviously this example is just for 5 products but i have more than a thousand)

Any ideas? I have tried with aggr, rangesum. But the problem is that i lose the order which makes the sum with a different set of values. Also with set analysis but i have not reach the target

Any help would be appreciated.

Regards,

Re: IDENTIFY RULE 80/20 DYNAMICALLY UNDER A CHART

alexandros17 — Fri, 28 Feb 2014 17:04:04 GMT

Use Pareto Select .... lokk for it in help guide

Re: IDENTIFY RULE 80/20 DYNAMICALLY UNDER A CHART

Fri, 28 Feb 2014 17:19:08 GMT

thanks for your reply Alessandro, But I forgot to mention that i already know that option but i do not want to select i want to set it in a label, as far as i know Pareto Select is only actionable thorough a button, and it will filter out the data, but not only display the result within a label which is my question