https://community.qlik.com/t5/QlikView/Pareto-Chart/m-p/1676829#M455875 <P>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)"</P><P>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 &lt;= 80% and then one bar for 100% with a spike from 80% to 100%. How do I accomplish this?&nbsp; Any help is much appreciated.</P> Tue, 18 Feb 2020 21:12:41 GMT sreelathamohan 2020-02-18T21:12:41Z https://community.qlik.com/t5/QlikView/Pareto-Chart/m-p/1676829#M455875 <P>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)"</P><P>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 &lt;= 80% and then one bar for 100% with a spike from 80% to 100%. How do I accomplish this?&nbsp; Any help is much appreciated.</P> Tue, 18 Feb 2020 21:12:41 GMT https://community.qlik.com/t5/QlikView/Pareto-Chart/m-p/1676829#M455875 sreelathamohan 2020-02-18T21:12:41Z https://community.qlik.com/t5/QlikView/Pareto-Chart/m-p/1687439#M455876 <P>I think the following Design Blog posts should likely get you what you need:</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis/ba-p/1468497" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis/ba-p/1468497</A></P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis-Revisited/ba-p/1473684" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis-Revisited/ba-p/1473684</A></P><P>Regards,<BR />Brett</P> Tue, 24 Mar 2020 19:03:30 GMT https://community.qlik.com/t5/QlikView/Pareto-Chart/m-p/1687439#M455876 Brett_Bleess 2020-03-24T19:03:30Z