topic Calculation question in QlikView https://community.qlik.com/t5/QlikView/Calculation-question/m-p/1374029#M459404 <HTML><HEAD></HEAD><BODY><P>Hello:</P><P></P><P>Trying to get this calculation in a table.</P><P>So the ETE% is a division&nbsp; of Count of product a&nbsp; by total count of All products for the Salesrep + added</P><P>common products for other salesreps.</P><P></P><P>So for example, the first line would be:</P><P>10 / (10 + 10 + 10 + 20 + 20) = 14%.</P><P></P><P>How do I count all the products for a Salesrep + add sales of common products to Salesrep James.</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="473"><TBODY><TR><TD class="xl66" height="20" width="223">Salesrep</TD><TD class="xl66" style="border-left: none;" width="84">Product</TD><TD class="xl66" style="border-left: none;" width="81">Qty Sold</TD><TD class="xl67" style="border-left: none;" width="85">ETE%</TD></TR><TR><TD class="xl69" height="20" style="border-top: none;">James</TD><TD class="xl69" style="border-top: none; border-left: none;">A</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">14%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">James</TD><TD class="xl66" style="border-top: none; border-left: none;">B</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">James</TD><TD class="xl66" style="border-top: none; border-left: none;">C</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;"> </TD><TD class="xl66" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none; border-left: none;"> </TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">John</TD><TD class="xl66" style="border-top: none; border-left: none;">A</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">29%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">John</TD><TD class="xl66" style="border-top: none; border-left: none;">B</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">29%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">John</TD><TD class="xl66" style="border-top: none; border-left: none;">D</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">100%</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 29 Sep 2017 19:42:59 GMT gerrycastellino 2017-09-29T19:42:59Z Calculation question https://community.qlik.com/t5/QlikView/Calculation-question/m-p/1374029#M459404 <HTML><HEAD></HEAD><BODY><P>Hello:</P><P></P><P>Trying to get this calculation in a table.</P><P>So the ETE% is a division&nbsp; of Count of product a&nbsp; by total count of All products for the Salesrep + added</P><P>common products for other salesreps.</P><P></P><P>So for example, the first line would be:</P><P>10 / (10 + 10 + 10 + 20 + 20) = 14%.</P><P></P><P>How do I count all the products for a Salesrep + add sales of common products to Salesrep James.</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="473"><TBODY><TR><TD class="xl66" height="20" width="223">Salesrep</TD><TD class="xl66" style="border-left: none;" width="84">Product</TD><TD class="xl66" style="border-left: none;" width="81">Qty Sold</TD><TD class="xl67" style="border-left: none;" width="85">ETE%</TD></TR><TR><TD class="xl69" height="20" style="border-top: none;">James</TD><TD class="xl69" style="border-top: none; border-left: none;">A</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">14%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">James</TD><TD class="xl66" style="border-top: none; border-left: none;">B</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">James</TD><TD class="xl66" style="border-top: none; border-left: none;">C</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;"> </TD><TD class="xl66" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none; border-left: none;"> </TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">John</TD><TD class="xl66" style="border-top: none; border-left: none;">A</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">29%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">John</TD><TD class="xl66" style="border-top: none; border-left: none;">B</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">29%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">John</TD><TD class="xl66" style="border-top: none; border-left: none;">D</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">100%</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 29 Sep 2017 19:42:59 GMT https://community.qlik.com/t5/QlikView/Calculation-question/m-p/1374029#M459404 gerrycastellino 2017-09-29T19:42:59Z