topic Re: Soma condicional in Brasil https://community.qlik.com/t5/Brasil/Soma-condicional/m-p/742925#M22465 <HTML><HEAD></HEAD><BODY><P>André, você poderia utilizar somente um SUM(DISTINCT <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">TotalNF), porém isso não é recomendado pois se tiver duas notas diferentes com o mesmo valor ele considerará somente um valor.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">O correto é aplicar a fórmula com AGGR, seria mais ou menos assim:</SPAN></P><P></P><P><SPAN style="font-size: 13.3333330154419px;">SUM(AGGR(SUM(DISTINCT </SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">TotalNF), Nota))</SPAN></P></BODY></HTML> Wed, 04 Feb 2015 12:22:19 GMT nicolett_yuri 2015-02-04T12:22:19Z Soma condicional https://community.qlik.com/t5/Brasil/Soma-condicional/m-p/742924#M22464 <HTML><HEAD></HEAD><BODY><P>Pessoal,</P><P></P><P>Tenho a seguinte situação: Load Nota, TotalNF;</P><P>Onde:</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 128px;"><TBODY><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; width: 48pt;" width="64">Nota</TD><TD class="xl64" style="border-left: none; width: 48pt;" width="64">TotalNF</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl65" height="20" style="height: 15.0pt; border-top: none;">101</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">234,52</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl67" height="20" style="height: 15.0pt; border-top: none;">101</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">234,52</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl67" height="20" style="height: 15.0pt; border-top: none;">101</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">234,52</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl65" height="20" style="height: 15.0pt; border-top: none;">102</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">125,24</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl67" height="20" style="height: 15.0pt; border-top: none;">102</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">125,24</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl65" height="20" style="height: 15.0pt; border-top: none;">103</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">35,4</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl67" height="20" style="height: 15.0pt; border-top: none;">103</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">35,4</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;"></TD><TD></TD></TR><TR style="height: 15.0pt;"><TD class="xl63" height="20" style="height: 15.0pt;">Soma</TD><TD align="right" class="xl63">395,16</TD></TR></TBODY></TABLE><P>Qual formula aplicar no gráfico para que não some os Totais de NF iguais?</P><P>Obrigado aos que puderem ajudar.</P></BODY></HTML> Wed, 04 Feb 2015 12:19:06 GMT https://community.qlik.com/t5/Brasil/Soma-condicional/m-p/742924#M22464 Anonymous 2015-02-04T12:19:06Z Re: Soma condicional https://community.qlik.com/t5/Brasil/Soma-condicional/m-p/742925#M22465 <HTML><HEAD></HEAD><BODY><P>André, você poderia utilizar somente um SUM(DISTINCT <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">TotalNF), porém isso não é recomendado pois se tiver duas notas diferentes com o mesmo valor ele considerará somente um valor.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">O correto é aplicar a fórmula com AGGR, seria mais ou menos assim:</SPAN></P><P></P><P><SPAN style="font-size: 13.3333330154419px;">SUM(AGGR(SUM(DISTINCT </SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">TotalNF), Nota))</SPAN></P></BODY></HTML> Wed, 04 Feb 2015 12:22:19 GMT https://community.qlik.com/t5/Brasil/Soma-condicional/m-p/742925#M22465 nicolett_yuri 2015-02-04T12:22:19Z Re: Soma condicional https://community.qlik.com/t5/Brasil/Soma-condicional/m-p/742926#M22466 <HTML><HEAD></HEAD><BODY><P>Sum( aggr(sum(distinct TotalNF),Nota))</P><P></P><P> </P><P></P><P> </P><P></P><P> </P><P></P><P>De: André Barros </P><P>Enviada em: quarta-feira, 4 de fevereiro de 2015 10:20</P><P>Para: ALESSANDRO FURTADO</P><P>Assunto: - Soma condicional</P><P></P><P> </P><P></P><P></P><P></P><P></P><P> &lt;http://community.qlik.com/?et=watches.email.thread&gt; Qlik Community </P><P></P><P></P><P> </P><P></P><P></P><P></P><P>Soma condicional </P><P></P><P></P><P>criado por André Barros &lt;http://community.qlik.com/people/albarros?et=watches.email.thread&gt; em Qlik Brasil - Visualize a discussão completa &lt;http://community.qlik.com/message/707164?et=watches.email.thread#707164&gt;</P></BODY></HTML> Wed, 04 Feb 2015 12:24:05 GMT https://community.qlik.com/t5/Brasil/Soma-condicional/m-p/742926#M22466 afurtado 2015-02-04T12:24:05Z Re: Soma condicional https://community.qlik.com/t5/Brasil/Soma-condicional/m-p/742927#M22467 <HTML><HEAD></HEAD><BODY><P>Resolvido galera.</P><P></P><P>Obrigado.</P></BODY></HTML> Wed, 04 Feb 2015 12:30:09 GMT https://community.qlik.com/t5/Brasil/Soma-condicional/m-p/742927#M22467 Anonymous 2015-02-04T12:30:09Z