topic Re: Subtotal principal errado in Brasil https://community.qlik.com/t5/Brasil/Subtotal-principal-errado/m-p/835253#M26973 <HTML><HEAD></HEAD><BODY><P>sem conhecer a sua base e dando um chute,</P><P></P><P>quem sabe</P><P></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum(QUANTIDADE * VALOR_FRETE)</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">em alguns casos, um aggr pode resolver....<BR /></SPAN></P></BODY></HTML> Thu, 09 Jul 2015 00:20:44 GMT afurtado 2015-07-09T00:20:44Z Subtotal principal errado https://community.qlik.com/t5/Brasil/Subtotal-principal-errado/m-p/835247#M26967 <HTML><HEAD></HEAD><BODY><P>Boa tarde amigo, estou com um erro aqui que nao estou conseguindo encontrar...</P><P></P><P>Conforme anexo, os sbtotais em verde, estão ok, mas o totall geral em VERMELHO está errado, o poruqe disso.....</P><P></P><P>Isso me ocorre no valor do frete e no Frete KG</P><P></P><P>VALOR FRETE - =(sum(QUANTIDADE) * sum(VALOR_FRETE))</P><P></P><P>FRETE KG - =((sum(QUANTIDADE) * sum(VALOR_FRETE)) / (sum(QUANTIDADE)))</P><P></P><P><IMG alt="erro_qv.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/92305_erro_qv.png" style="height: 292px; width: 620px;" /></P><P></P><P>Obrigado!</P></BODY></HTML> Wed, 08 Jul 2015 20:36:39 GMT https://community.qlik.com/t5/Brasil/Subtotal-principal-errado/m-p/835247#M26967 ruzivao1980 2015-07-08T20:36:39Z Re: Subtotal principal errado https://community.qlik.com/t5/Brasil/Subtotal-principal-errado/m-p/835248#M26968 <HTML><HEAD></HEAD><BODY><P>Eu ligo 2 tabelas para encontrar o valor do frete...</P><P></P><P>Pedido e Fretes, com o campo UF.</P></BODY></HTML> Wed, 08 Jul 2015 20:40:25 GMT https://community.qlik.com/t5/Brasil/Subtotal-principal-errado/m-p/835248#M26968 ruzivao1980 2015-07-08T20:40:25Z Re: Subtotal principal errado https://community.qlik.com/t5/Brasil/Subtotal-principal-errado/m-p/835249#M26969 <HTML><HEAD></HEAD><BODY><P>acho que é a mesma resposta da questão abaixo:</P><P></P><P>https: / /community.qlik.com/thread/171743</P></BODY></HTML> Wed, 08 Jul 2015 20:43:29 GMT https://community.qlik.com/t5/Brasil/Subtotal-principal-errado/m-p/835249#M26969 Anonymous 2015-07-08T20:43:29Z Re: Subtotal principal errado https://community.qlik.com/t5/Brasil/Subtotal-principal-errado/m-p/835250#M26970 <HTML><HEAD></HEAD><BODY><P>Não abre!!!!</P></BODY></HTML> Wed, 08 Jul 2015 21:05:44 GMT https://community.qlik.com/t5/Brasil/Subtotal-principal-errado/m-p/835250#M26970 ruzivao1980 2015-07-08T21:05:44Z Re: Subtotal principal errado https://community.qlik.com/t5/Brasil/Subtotal-principal-errado/m-p/835251#M26971 <HTML><HEAD></HEAD><BODY><P>O Egnaldo colocou espacos por causa do moderador.&nbsp;&nbsp; Se tirar os espacos abre....</P></BODY></HTML> Wed, 08 Jul 2015 23:55:31 GMT https://community.qlik.com/t5/Brasil/Subtotal-principal-errado/m-p/835251#M26971 afurtado 2015-07-08T23:55:31Z Re: Subtotal principal errado https://community.qlik.com/t5/Brasil/Subtotal-principal-errado/m-p/835252#M26972 <HTML><HEAD></HEAD><BODY><P>Roosevelt, tem outro detalhe.</P><P></P><P>Normalmente quando tem um calculo&nbsp; sum(A) * sum(B) pode funcionar dependendo das dimensões, mas quando chego no total, a expressão nem sempre vai dar certo pois sera o total do sum(A)&nbsp; * o total do sum(B).</P><P></P><P>Veja um exemplo:&nbsp; Aonde a coluna Total seria a expressão&nbsp;&nbsp;&nbsp; sum(ValorUnit) * sum(Qtde)</P><P></P><P>Dimensao&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Valor Unit.&nbsp;&nbsp;&nbsp;&nbsp; Qtde&nbsp;&nbsp; Total</P><P>Linha1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>Linha2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P></P><P>TOTAL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 900</P><P></P><P>sendo que o correto seria 500</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Dimensao</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Valor Unit</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Qtde</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>sum(Valor) * sum(Qtde)</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>sum(Valor *Qtde)</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#f5f5f5"><TD bgcolor="#f5f5f5"> </TD><TD bgcolor="#f5f5f5"><STRONG>30 </STRONG></TD><TD bgcolor="#f5f5f5"><STRONG>30 </STRONG></TD><TD bgcolor="#f5f5f5"><STRONG>900 </STRONG></TD><TD bgcolor="#f5f5f5"><STRONG>500 </STRONG></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Linha1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">10</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">10</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Linha2</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">20</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">20</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">400</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">400</SPAN></TD></TR></TBODY></TABLE><P></P><P>Se usar campos que não estão no mesmo registro, sera criado em tempo de calculo uma tabela virtual para efetuar o calculo.&nbsp; Este é um exemplo, depende da sua modelagem, mas para lhe ajudar no calculo do seu grafico.</P></BODY></HTML> Thu, 09 Jul 2015 00:19:29 GMT https://community.qlik.com/t5/Brasil/Subtotal-principal-errado/m-p/835252#M26972 afurtado 2015-07-09T00:19:29Z Re: Subtotal principal errado https://community.qlik.com/t5/Brasil/Subtotal-principal-errado/m-p/835253#M26973 <HTML><HEAD></HEAD><BODY><P>sem conhecer a sua base e dando um chute,</P><P></P><P>quem sabe</P><P></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum(QUANTIDADE * VALOR_FRETE)</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">em alguns casos, um aggr pode resolver....<BR /></SPAN></P></BODY></HTML> Thu, 09 Jul 2015 00:20:44 GMT https://community.qlik.com/t5/Brasil/Subtotal-principal-errado/m-p/835253#M26973 afurtado 2015-07-09T00:20:44Z Re: Subtotal principal errado https://community.qlik.com/t5/Brasil/Subtotal-principal-errado/m-p/835254#M26974 <HTML><HEAD></HEAD><BODY><P>Obrigado Galera....</P></BODY></HTML> Thu, 09 Jul 2015 13:53:01 GMT https://community.qlik.com/t5/Brasil/Subtotal-principal-errado/m-p/835254#M26974 ruzivao1980 2015-07-09T13:53:01Z