topic Re: Sum Distinct in QlikView https://community.qlik.com/t5/QlikView/Sum-Distinct/m-p/924128#M468992 <HTML><HEAD></HEAD><BODY><P>=Sum( Aggr( Only(Monto), Producto))</P></BODY></HTML> Fri, 31 Jul 2015 16:29:47 GMT swuehl 2015-07-31T16:29:47Z Sum Distinct https://community.qlik.com/t5/QlikView/Sum-Distinct/m-p/924126#M468990 <HTML><HEAD></HEAD><BODY><P>Hola, soy nuevo en QlikView y espero puedan entender cual es mi duda. Lo que quiero hacer es sumar todos los montos que sean de distintos, por ejemplo, productos. Algo así</P><P></P><TABLE border="1" class="jiveBorder" height="124" style="border: 1px solid rgb(0, 0, 0); width: 319px; height: 108px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Producto</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Monto</STRONG></TH></TR><TR><TD style="padding: 2px;">Producto A</TD><TD style="padding: 2px;">15</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">Producto A</SPAN></TD><TD style="padding: 2px;">15</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">Producto B</SPAN></TD><TD style="padding: 2px;">20</TD></TR><TR><TD style="padding: 2px;">Producto C</TD><TD style="padding: 2px;">20</TD></TR></TBODY></TABLE><P></P><P>La suma debería darme 55, Producto A 15, Producto B 20 y Producto C 20.</P><P>Intente hacer un <SPAN style="text-decoration: underline;">SUM( Distinct Monto)</SPAN> pero solo me dio 35 porque parece que solo suma los montos distintos entre si.</P><P></P><P>Gracias por su ayuda.</P></BODY></HTML> Fri, 31 Jul 2015 16:24:42 GMT https://community.qlik.com/t5/QlikView/Sum-Distinct/m-p/924126#M468990 stvn_003 2015-07-31T16:24:42Z Re: Sum Distinct https://community.qlik.com/t5/QlikView/Sum-Distinct/m-p/924127#M468991 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Sum(Aggr(Avg(Amount), Product))</STRONG></P></BODY></HTML> Fri, 31 Jul 2015 16:29:15 GMT https://community.qlik.com/t5/QlikView/Sum-Distinct/m-p/924127#M468991 sunny_talwar 2015-07-31T16:29:15Z Re: Sum Distinct https://community.qlik.com/t5/QlikView/Sum-Distinct/m-p/924128#M468992 <HTML><HEAD></HEAD><BODY><P>=Sum( Aggr( Only(Monto), Producto))</P></BODY></HTML> Fri, 31 Jul 2015 16:29:47 GMT https://community.qlik.com/t5/QlikView/Sum-Distinct/m-p/924128#M468992 swuehl 2015-07-31T16:29:47Z Re: Sum Distinct https://community.qlik.com/t5/QlikView/Sum-Distinct/m-p/1826976#M1214046 <P>Hi <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp;... this works fine but... can you explain why does this is necesary??</P> Fri, 06 Aug 2021 02:32:30 GMT https://community.qlik.com/t5/QlikView/Sum-Distinct/m-p/1826976#M1214046 Gabo77 2021-08-06T02:32:30Z