Pareto Chart

[sreelathamohan]

I have a pareto chart by dimension called "Reason Detail". I have 2 expressions - one for the bar chart which is "sum(qty)"and other for line chart which is the cumulative % "Rangesum(above(sum(qty),0,RowNo())/sum(total qty)"

I need to show bars until 80% cumulative % with their respective dimension values and then a sharp spike from 80% to 100% with just one bar named as "Others". In other words my cumulative line should show bars <= 80% and then one bar for 100% with a spike from 80% to 100%. How do I accomplish this?  Any help is much appreciated.

[Brett_Bleess]

I think the following Design Blog posts should likely get you what you need:

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis/ba-p/1468497

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis-Revisited/ba-p/1473684

Regards,
Brett