topic Calculo por tipo in Brasil https://community.qlik.com/t5/Brasil/Calculo-por-tipo/m-p/788859#M24770 <HTML><HEAD></HEAD><BODY><P>bom dia.</P><P></P><P>Pessoal,</P><P></P><P>Venho aqui novamente pedir ajuda de vocês, estou tentando fazer um gráfico/tabela simples onde eu mostre o quanto representa a venda do vendedor por loja com forme exemplo.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 615px;"><TBODY><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt; width: 48pt;" width="64">loja</TD><TD style="width: 50pt;" width="67">vendedor</TD><TD style="width: 56pt;" width="74">total loja</TD><TD style="width: 107pt;" width="143">total venda vendedor</TD><TD style="width: 200pt;" width="267">Quanto a venda do vendedor representa ?</TD></TR><TR style="height: 15.0pt;"><TD align="right" height="20" style="height: 15.0pt;">19</TD><TD>A</TD><TD class="xl64">R$&nbsp;&nbsp; 100,00</TD><TD class="xl64">R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50,00</TD><TD align="right" class="xl63">50%</TD></TR><TR style="height: 15.0pt;"><TD align="right" height="20" style="height: 15.0pt;">19</TD><TD>B</TD><TD class="xl64">R$&nbsp;&nbsp; 100,00</TD><TD class="xl64">R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30,00</TD><TD align="right" class="xl63">30%</TD></TR><TR style="height: 15.0pt;"><TD align="right" height="20" style="height: 15.0pt;">19</TD><TD>C</TD><TD class="xl64">R$&nbsp;&nbsp; 100,00</TD><TD class="xl64">R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20,00</TD><TD align="right" class="xl63">20%</TD></TR><TR style="height: 15.0pt;"><TD align="right" height="20" style="height: 15.0pt;">20</TD><TD>A</TD><TD class="xl64">R$&nbsp;&nbsp; 200,00</TD><TD class="xl64">R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100,00</TD><TD align="right" class="xl63">50%</TD></TR><TR style="height: 15.0pt;"><TD align="right" height="20" style="height: 15.0pt;">20</TD><TD>B</TD><TD class="xl64">R$&nbsp;&nbsp; 200,00</TD><TD class="xl64">R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50,00</TD><TD align="right" class="xl63">25%</TD></TR><TR style="height: 15.0pt;"><TD align="right" height="20" style="height: 15.0pt;">20</TD><TD>C</TD><TD class="xl64">R$&nbsp;&nbsp; 200,00</TD><TD class="xl64">R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50,00</TD><TD align="right" class="xl63">25%</TD></TR></TBODY></TABLE><P></P><P>Consegui fazer com Aggr mas so calculo para os primeiros.</P><P>Tenho como Dimensão Loja e Vendedor - (por que uma loja pode ter um vendedor com o mesmo código e nome)</P><P>nas expressões fiz desta forma: </P><P></P><P>Aggr(sum(TotalItem),Lojas)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Aggr(sum(TotalItem),chaveVend)</P><P>Aggr(sum(TotalItem),Lojas) / Aggr(sum(TotalItem),chaveVend)</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR><TD colspan="1">Loja</TD><TD colspan="1">Vendedor</TD><TD colspan="1">Total Loja</TD><TD colspan="1">Total Venda Vendedor</TD><TD colspan="1">Representa Venda sobre Total</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><P><SPAN style="color: #363636;">19</SPAN></P></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0469-2151</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">131465,70</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1001,16</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">86,69%</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">19</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0469-2011</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">44965,58</SPAN></TD><TD bgcolor="#ffffff"></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">19</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0469-2046</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">44885,37</SPAN></TD><TD bgcolor="#ffffff"></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">20</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0248-2038</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">922541,24</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">120911,25</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">5,04%</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">20</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0248-1481</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">151527,59</SPAN></TD><TD bgcolor="#ffffff"></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">21</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0205-2054</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">464991,80</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">37093,49</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">8,28%</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">21</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0205-2046</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">69901,45</SPAN></TD><TD bgcolor="#ffffff"></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff">21</TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0205-2062</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">61187,14</SPAN></TD><TD bgcolor="#ffffff"></TD></TR></TBODY></TABLE><P></P><P>Como Consigo ajustar isso, para que faça em todas as linas.</P><P>Obrigado.</P></BODY></HTML> Wed, 14 Jan 2015 12:44:36 GMT 2015-01-14T12:44:36Z Calculo por tipo https://community.qlik.com/t5/Brasil/Calculo-por-tipo/m-p/788859#M24770 <HTML><HEAD></HEAD><BODY><P>bom dia.</P><P></P><P>Pessoal,</P><P></P><P>Venho aqui novamente pedir ajuda de vocês, estou tentando fazer um gráfico/tabela simples onde eu mostre o quanto representa a venda do vendedor por loja com forme exemplo.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 615px;"><TBODY><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt; width: 48pt;" width="64">loja</TD><TD style="width: 50pt;" width="67">vendedor</TD><TD style="width: 56pt;" width="74">total loja</TD><TD style="width: 107pt;" width="143">total venda vendedor</TD><TD style="width: 200pt;" width="267">Quanto a venda do vendedor representa ?</TD></TR><TR style="height: 15.0pt;"><TD align="right" height="20" style="height: 15.0pt;">19</TD><TD>A</TD><TD class="xl64">R$&nbsp;&nbsp; 100,00</TD><TD class="xl64">R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50,00</TD><TD align="right" class="xl63">50%</TD></TR><TR style="height: 15.0pt;"><TD align="right" height="20" style="height: 15.0pt;">19</TD><TD>B</TD><TD class="xl64">R$&nbsp;&nbsp; 100,00</TD><TD class="xl64">R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30,00</TD><TD align="right" class="xl63">30%</TD></TR><TR style="height: 15.0pt;"><TD align="right" height="20" style="height: 15.0pt;">19</TD><TD>C</TD><TD class="xl64">R$&nbsp;&nbsp; 100,00</TD><TD class="xl64">R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20,00</TD><TD align="right" class="xl63">20%</TD></TR><TR style="height: 15.0pt;"><TD align="right" height="20" style="height: 15.0pt;">20</TD><TD>A</TD><TD class="xl64">R$&nbsp;&nbsp; 200,00</TD><TD class="xl64">R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100,00</TD><TD align="right" class="xl63">50%</TD></TR><TR style="height: 15.0pt;"><TD align="right" height="20" style="height: 15.0pt;">20</TD><TD>B</TD><TD class="xl64">R$&nbsp;&nbsp; 200,00</TD><TD class="xl64">R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50,00</TD><TD align="right" class="xl63">25%</TD></TR><TR style="height: 15.0pt;"><TD align="right" height="20" style="height: 15.0pt;">20</TD><TD>C</TD><TD class="xl64">R$&nbsp;&nbsp; 200,00</TD><TD class="xl64">R$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50,00</TD><TD align="right" class="xl63">25%</TD></TR></TBODY></TABLE><P></P><P>Consegui fazer com Aggr mas so calculo para os primeiros.</P><P>Tenho como Dimensão Loja e Vendedor - (por que uma loja pode ter um vendedor com o mesmo código e nome)</P><P>nas expressões fiz desta forma: </P><P></P><P>Aggr(sum(TotalItem),Lojas)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Aggr(sum(TotalItem),chaveVend)</P><P>Aggr(sum(TotalItem),Lojas) / Aggr(sum(TotalItem),chaveVend)</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR><TD colspan="1">Loja</TD><TD colspan="1">Vendedor</TD><TD colspan="1">Total Loja</TD><TD colspan="1">Total Venda Vendedor</TD><TD colspan="1">Representa Venda sobre Total</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><P><SPAN style="color: #363636;">19</SPAN></P></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0469-2151</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">131465,70</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1001,16</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">86,69%</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">19</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0469-2011</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">44965,58</SPAN></TD><TD bgcolor="#ffffff"></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">19</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0469-2046</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">44885,37</SPAN></TD><TD bgcolor="#ffffff"></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">20</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0248-2038</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">922541,24</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">120911,25</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">5,04%</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">20</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0248-1481</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">151527,59</SPAN></TD><TD bgcolor="#ffffff"></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">21</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0205-2054</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">464991,80</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">37093,49</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">8,28%</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">21</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0205-2046</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">69901,45</SPAN></TD><TD bgcolor="#ffffff"></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff">21</TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0205-2062</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">61187,14</SPAN></TD><TD bgcolor="#ffffff"></TD></TR></TBODY></TABLE><P></P><P>Como Consigo ajustar isso, para que faça em todas as linas.</P><P>Obrigado.</P></BODY></HTML> Wed, 14 Jan 2015 12:44:36 GMT https://community.qlik.com/t5/Brasil/Calculo-por-tipo/m-p/788859#M24770 2015-01-14T12:44:36Z Re: Calculo por tipo https://community.qlik.com/t5/Brasil/Calculo-por-tipo/m-p/788860#M24771 <HTML><HEAD></HEAD><BODY><P>Resolvido. </P><P></P><P>Coloquei noDistinct nas expressões da loja,&nbsp; ai colocou em todas as linhas.</P><P></P><P>Aggr(NODISTINCT sum(TotalItem),Lojas)</P><P>Aggr(NODISTINCT sum(TotalItem),Lojas) / Aggr(sum(TotalItem),chaveVend)</P><P></P><P>Mas sé alguém tiver uma ideia melhor estou aberto a sugestões.</P></BODY></HTML> Wed, 14 Jan 2015 13:10:16 GMT https://community.qlik.com/t5/Brasil/Calculo-por-tipo/m-p/788860#M24771 2015-01-14T13:10:16Z