topic Re: How to prepare chart of rule 80:20? in QlikView https://community.qlik.com/t5/QlikView/How-to-prepare-chart-of-rule-80-20/m-p/91999#M14889 <HTML><HEAD></HEAD><BODY><P>Here you are</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/208096_Capture.PNG" style="height: 531px; width: 620px;" /></P><P></P><P>Dimension</P><P><STRONG>=If(Aggr(RangeSum(Above(Sum(Sales), 0, RowNo())) / Sum(Total Sales), (Product, (=Sum(Sales), Desc))) &lt;= 0.8099, '80%', '20%')</STRONG></P><P></P><P>Expression</P><P></P><P>!</P><P><STRONG>Sum(Sales)</STRONG></P><P><STRONG>Count(Product)</STRONG></P></BODY></HTML> Tue, 17 Jul 2018 13:06:18 GMT sunny_talwar 2018-07-17T13:06:18Z How to prepare chart of rule 80:20? https://community.qlik.com/t5/QlikView/How-to-prepare-chart-of-rule-80-20/m-p/91995#M14885 <HTML><HEAD></HEAD><BODY><P>Please help me to prepare table as result(Photo)</P></BODY></HTML> Mon, 16 Jul 2018 14:09:06 GMT https://community.qlik.com/t5/QlikView/How-to-prepare-chart-of-rule-80-20/m-p/91995#M14885 panwipa2528 2018-07-16T14:09:06Z Re: How to prepare chart of rule 80:20? https://community.qlik.com/t5/QlikView/How-to-prepare-chart-of-rule-80-20/m-p/91996#M14886 <HTML><HEAD></HEAD><BODY><P>Do you have qv12 or above?</P></BODY></HTML> Mon, 16 Jul 2018 14:48:57 GMT https://community.qlik.com/t5/QlikView/How-to-prepare-chart-of-rule-80-20/m-p/91996#M14886 sunny_talwar 2018-07-16T14:48:57Z Re: How to prepare chart of rule 80:20? https://community.qlik.com/t5/QlikView/How-to-prepare-chart-of-rule-80-20/m-p/91997#M14887 <HTML><HEAD></HEAD><BODY><P>I user version 12.10.0.0</P></BODY></HTML> Tue, 17 Jul 2018 02:03:24 GMT https://community.qlik.com/t5/QlikView/How-to-prepare-chart-of-rule-80-20/m-p/91997#M14887 panwipa2528 2018-07-17T02:03:24Z Re: How to prepare chart of rule 80:20? https://community.qlik.com/t5/QlikView/How-to-prepare-chart-of-rule-80-20/m-p/91998#M14888 <HTML><HEAD></HEAD><BODY><P>May be try these, for your chart type:</P><P><A class="jive-link-external-small" href="https://community.qlikview.com/blogs/qlikviewdesignblog/2013/12/09/pareto-analysis" rel="nofollow" target="_blank">https://community.qlikview.com/blogs/qlikviewdesignblog/2013/12/09/pareto-analysis</A></P><P></P><P><A class="jive-link-thread-small" data-containerid="2052" data-containertype="14" data-objectid="32008" data-objecttype="1" href="https://community.qlik.com/thread/32008">https://community.qlik.com/thread/32008</A></P></BODY></HTML> Tue, 17 Jul 2018 12:57:32 GMT https://community.qlik.com/t5/QlikView/How-to-prepare-chart-of-rule-80-20/m-p/91998#M14888 BalaBhaskar_Qlik 2018-07-17T12:57:32Z Re: How to prepare chart of rule 80:20? https://community.qlik.com/t5/QlikView/How-to-prepare-chart-of-rule-80-20/m-p/91999#M14889 <HTML><HEAD></HEAD><BODY><P>Here you are</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/208096_Capture.PNG" style="height: 531px; width: 620px;" /></P><P></P><P>Dimension</P><P><STRONG>=If(Aggr(RangeSum(Above(Sum(Sales), 0, RowNo())) / Sum(Total Sales), (Product, (=Sum(Sales), Desc))) &lt;= 0.8099, '80%', '20%')</STRONG></P><P></P><P>Expression</P><P></P><P>!</P><P><STRONG>Sum(Sales)</STRONG></P><P><STRONG>Count(Product)</STRONG></P></BODY></HTML> Tue, 17 Jul 2018 13:06:18 GMT https://community.qlik.com/t5/QlikView/How-to-prepare-chart-of-rule-80-20/m-p/91999#M14889 sunny_talwar 2018-07-17T13:06:18Z