topic Sum repeated values​​. in QlikView https://community.qlik.com/t5/QlikView/Sum-repeated-values/m-p/315476#M116429 <HTML><HEAD></HEAD><BODY><P>It looks like the equations is doing right.</P><P></P><P>Could you tell me why it should be 24?. Please explain the logic</P></BODY></HTML> Tue, 20 Dec 2011 19:25:41 GMT 2011-12-20T19:25:41Z Sum repeated values​​. https://community.qlik.com/t5/QlikView/Sum-repeated-values/m-p/315475#M116428 <HTML><HEAD></HEAD><BODY><P>Hello all.</P><P></P><P>I'm struggling to find the correct function.</P><P>In this table, the result must be 24.<BR />The sum should consider the repeated numbers.</P><P>Thank you.</P><P></P><P></P><P></P><P><OBJECT classid="CLSID:B6824343-14A4-4425-92E2-BC9722B2092D" height="461" hspace="0" id="QlikOCX" width="530"><PARAM name="_Version" value="655360" /><PARAM name="_ExtentX" value="14022" /><PARAM name="_ExtentY" value="12197" /><PARAM name="_StockProps" value="0" /><PARAM name="DocName" value="" /><PARAM name="UserName" /><PARAM name="Password" /><PARAM name="Publisher" /><PARAM name="AccessMode" value="0" /><PARAM name="AllowDialog" value="1" /><PARAM name="SRC" /><PARAM name="AutoScan" value="1" /><PARAM name="ProductLevel" value="49783932" /><PARAM name="ObjectID" value="Document\CH02" /></OBJECT></P></BODY></HTML> Tue, 20 Dec 2011 19:00:49 GMT https://community.qlik.com/t5/QlikView/Sum-repeated-values/m-p/315475#M116428 Anonymous 2011-12-20T19:00:49Z Sum repeated values​​. https://community.qlik.com/t5/QlikView/Sum-repeated-values/m-p/315476#M116429 <HTML><HEAD></HEAD><BODY><P>It looks like the equations is doing right.</P><P></P><P>Could you tell me why it should be 24?. Please explain the logic</P></BODY></HTML> Tue, 20 Dec 2011 19:25:41 GMT https://community.qlik.com/t5/QlikView/Sum-repeated-values/m-p/315476#M116429 2011-12-20T19:25:41Z Re: Sum repeated values​​. https://community.qlik.com/t5/QlikView/Sum-repeated-values/m-p/315477#M116430 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>aggr(sum( distinct Quant_Fornecedores),Fornecedor)</P><P></P><P></P><P>(Change the Total Mode to Sum of Rows)</P></BODY></HTML> Tue, 20 Dec 2011 19:27:09 GMT https://community.qlik.com/t5/QlikView/Sum-repeated-values/m-p/315477#M116430 2011-12-20T19:27:09Z Sum repeated values​​. https://community.qlik.com/t5/QlikView/Sum-repeated-values/m-p/315478#M116431 <HTML><HEAD></HEAD><BODY><P> <BR /><SPAN class="hps">I need to count how many COD_FORNECEDOR&nbsp; I have&nbsp;&nbsp; for NRO_SEQ_PEDIDO.</SPAN></P><P><SPAN class="hps"> </SPAN></P><P><SPAN class="hps">Note that I have 2 different records in the field NRO_SEQ_PEDIDO<BR /> and 4 different records in the COD_FORNECEDOR field .</SPAN></P><P><SPAN class="hps">The correct result is 4 records.<BR /></SPAN></P><P></P><P></P><P> NRO_SEQ_PEDIDO&nbsp;&nbsp;&nbsp;&nbsp; COD_FORNECEDOR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SUM</P><P>&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;&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>978645&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;&nbsp;&nbsp; 19022&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; 2</P><P>978645&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;&nbsp;&nbsp; 19782&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; 2</P><P>978795&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;&nbsp;&nbsp;&nbsp;&nbsp; 3112&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; 2</P><P>978795&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;&nbsp;&nbsp;&nbsp;&nbsp; 8782&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; 2</P><P></P><P></P><DIV class="mcePaste" id="_mcePaste" style="position: absolute; width: 1px; height: 1px; overflow: hidden; top: 0px; left: -10000px;"></DIV></BODY></HTML> Tue, 20 Dec 2011 19:49:01 GMT https://community.qlik.com/t5/QlikView/Sum-repeated-values/m-p/315478#M116431 Anonymous 2011-12-20T19:49:01Z Sum repeated values​​. https://community.qlik.com/t5/QlikView/Sum-repeated-values/m-p/315479#M116432 <HTML><HEAD></HEAD><BODY><P>Try&nbsp; this </P><P></P><P>aggr(count(Distinct <SPAN class="hps">COD_FORNECEDOR</SPAN>),<SPAN class="hps">NRO_SEQ_PEDIDO)</SPAN></P></BODY></HTML> Tue, 20 Dec 2011 19:59:09 GMT https://community.qlik.com/t5/QlikView/Sum-repeated-values/m-p/315479#M116432 2011-12-20T19:59:09Z