topic How to classify my products between A, B or C ? in QlikView https://community.qlik.com/t5/QlikView/How-to-classify-my-products-between-A-B-or-C/m-p/33578#M5687 <HTML><HEAD></HEAD><BODY><P><STRONG>Hi Guys,</STRONG></P><P><SPAN style="text-decoration: underline;">I'm newbie here</SPAN>,</P><P></P><P>I just have a case in Qlikview that i can't solve it, and I need help.</P><P></P><P>I'm trying to classify my products between A, B or C.</P><P><BR />I Sort my sheet descending in "Value", after that I accumulate the percentual about total. </P><P><BR />This is the rule to calculation:</P><P></P><P>A =&nbsp; until 80% about total</P><P>B = until 95% about total</P><P>C = above 95% about total</P><P></P><P>How can I do it ?</P><P><BR />Please, take a look my attachment.</P><P><BR /><STRONG>Thanks for the help</STRONG> <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 15 Feb 2018 17:57:51 GMT leonardo_alexsa 2018-02-15T17:57:51Z How to classify my products between A, B or C ? https://community.qlik.com/t5/QlikView/How-to-classify-my-products-between-A-B-or-C/m-p/33578#M5687 <HTML><HEAD></HEAD><BODY><P><STRONG>Hi Guys,</STRONG></P><P><SPAN style="text-decoration: underline;">I'm newbie here</SPAN>,</P><P></P><P>I just have a case in Qlikview that i can't solve it, and I need help.</P><P></P><P>I'm trying to classify my products between A, B or C.</P><P><BR />I Sort my sheet descending in "Value", after that I accumulate the percentual about total. </P><P><BR />This is the rule to calculation:</P><P></P><P>A =&nbsp; until 80% about total</P><P>B = until 95% about total</P><P>C = above 95% about total</P><P></P><P>How can I do it ?</P><P><BR />Please, take a look my attachment.</P><P><BR /><STRONG>Thanks for the help</STRONG> <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 15 Feb 2018 17:57:51 GMT https://community.qlik.com/t5/QlikView/How-to-classify-my-products-between-A-B-or-C/m-p/33578#M5687 leonardo_alexsa 2018-02-15T17:57:51Z Re: How to classify my products between A, B or C ? https://community.qlik.com/t5/QlikView/How-to-classify-my-products-between-A-B-or-C/m-p/33579#M5688 <HTML><HEAD></HEAD><BODY><P>Check out this link</P><P><A href="https://community.qlik.com/qlik-blogpost/5065">Recipe for a Pareto Analysis – Revisited</A></P></BODY></HTML> Thu, 15 Feb 2018 18:03:13 GMT https://community.qlik.com/t5/QlikView/How-to-classify-my-products-between-A-B-or-C/m-p/33579#M5688 sunny_talwar 2018-02-15T18:03:13Z Re: How to classify my products between A, B or C ? https://community.qlik.com/t5/QlikView/How-to-classify-my-products-between-A-B-or-C/m-p/33580#M5689 <HTML><HEAD></HEAD><BODY><P>This topic helped me a loot. </P><P></P><P>Thank you!</P></BODY></HTML> Thu, 15 Feb 2018 19:16:18 GMT https://community.qlik.com/t5/QlikView/How-to-classify-my-products-between-A-B-or-C/m-p/33580#M5689 leonardo_alexsa 2018-02-15T19:16:18Z