Group relative full accumulation into groups of 80%, 15% and 5% rules

[#1]

Hi,

I need help here on how to dynamically group the relative full accumulation percentage into 80-15-5 rules and present the grouping in a stacked bar chart.

Attached is the qvw that I have done it using scripting but I am not able to recalculate the percentage based on other association/filters eg. product group. If filter the product by product group the 80-15-5 percentage should be recalculate and change. Now I am not able to achieve that because the calculation rules has been coded in the script.

Does anyone have idea on how to turn the below table chart into a stacked bar chart from front end instead of back-end scripting?

[Oleg_Troyansky]

Hi Joane,

I think you can find the answer in my recent blog article:

http://www.naturalsynergies.com/q-tip-11-so-how-many-customers-make-up-most-of-your-sales/

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

[hic · Accepted solution]

See Recipe for a Pareto Analysis

HIC

[#4]

Thanks Henric.

Very good article.