
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Pareto Chart
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.
.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
