topic Re: Products that makes 80% of sales. in QlikView https://community.qlik.com/t5/QlikView/Products-that-makes-80-of-sales/m-p/1002074#M952491 <HTML><HEAD></HEAD><BODY><P>What is the expression that you are using right now?</P></BODY></HTML> Wed, 16 Dec 2015 20:05:07 GMT sunny_talwar 2015-12-16T20:05:07Z Products that makes 80% of sales. https://community.qlik.com/t5/QlikView/Products-that-makes-80-of-sales/m-p/1002073#M952490 <HTML><HEAD></HEAD><BODY><P>I need to do a pareto, the pareto part is easy using rowno() and sorting by sales, but I have a problem now and I haven't been able to find an answer, I need to order my Straight Table by Product, but need the pareto column to have the right number as if it would be ordered by sales.</P><P></P><P>I want to do this, the problem is that I don't know how to calculate the pareto without ordering by sales. </P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Product</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Pareto</STRONG></TH></TR><TR><TD style="padding: 2px; text-align: center;">A</TD><TD style="padding: 2px; text-align: center;">$30,000</TD><TD style="padding: 2px; text-align: center;">85%</TD></TR><TR><TD style="padding: 2px; text-align: center;">B</TD><TD style="padding: 2px; text-align: center;"><SPAN style="font-size: 13.3333px;">$10,000</SPAN></TD><TD style="padding: 2px; text-align: center;">100%</TD></TR><TR><TD style="padding: 2px; text-align: center;">C</TD><TD style="padding: 2px; text-align: center;"><SPAN style="font-size: 13.3333px;">$80,000</SPAN></TD><TD style="padding: 2px; text-align: center;">40%</TD></TR><TR><TD style="padding: 2px; text-align: center;">D</TD><TD style="padding: 2px; text-align: center;"><SPAN style="font-size: 13.3333px;">$60,000</SPAN></TD><TD style="padding: 2px; text-align: center;">70%</TD></TR><TR><TD style="padding: 2px; text-align: center;">E</TD><TD style="padding: 2px; text-align: center;"><SPAN style="font-size: 13.3333px;">$20,000</SPAN></TD><TD style="padding: 2px; text-align: center;">95%</TD></TR></TBODY></TABLE></BODY></HTML> Sun, 29 Nov 2015 23:03:33 GMT https://community.qlik.com/t5/QlikView/Products-that-makes-80-of-sales/m-p/1002073#M952490 2015-11-29T23:03:33Z Re: Products that makes 80% of sales. https://community.qlik.com/t5/QlikView/Products-that-makes-80-of-sales/m-p/1002074#M952491 <HTML><HEAD></HEAD><BODY><P>What is the expression that you are using right now?</P></BODY></HTML> Wed, 16 Dec 2015 20:05:07 GMT https://community.qlik.com/t5/QlikView/Products-that-makes-80-of-sales/m-p/1002074#M952491 sunny_talwar 2015-12-16T20:05:07Z