Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

IDENTIFY RULE 80/20 DYNAMICALLY UNDER A CHART

Hi all,

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

customersales
a100
b400
c350
d150
e50

2. after ordering and get the cumulative frequency:

customersalescum. Frequency% cum.
b40040038.10%
c35075071.43%
d15090085.71%
a100100095.24%
e501050100.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,

2 Replies
alexandros17

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

Not applicable
Author

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