topic Re: problem with rangesum in QlikView https://community.qlik.com/t5/QlikView/problem-with-rangesum/m-p/1188965#M886220 <HTML><HEAD></HEAD><BODY><P>So the accumulation needs to restart when Filial Commercial changes? You will need to use Aggr() function to get this fixed. Exact expression would be rather difficult to provide because of the complexity, but if you can provide a sample, we might be able to help</P></BODY></HTML> Tue, 20 Sep 2016 20:13:15 GMT sunny_talwar 2016-09-20T20:13:15Z problem with rangesum https://community.qlik.com/t5/QlikView/problem-with-rangesum/m-p/1188964#M886219 <HTML><HEAD></HEAD><BODY><P><IMG alt="Tela1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/138075_Tela1.png" style="height: 193px; width: 620px;" /></P><P>The column "Saldo Quant" sum all dimensions but I would like to sum only the data in dimension "Data Comercial", "Numord movimento", "Nota" </P><P>The expresion used is this one: <STRONG>RangeSum(Above(TOTAL [Quantidade Movimento], 0, NoOfRows(TOTAL)))</STRONG></P><P></P><P>Best regards,</P><P>Felisberto</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/problem-with-rangesum/m-p/1188964#M886219 felisberto_joao 2020-11-25T16:16:04Z Re: problem with rangesum https://community.qlik.com/t5/QlikView/problem-with-rangesum/m-p/1188965#M886220 <HTML><HEAD></HEAD><BODY><P>So the accumulation needs to restart when Filial Commercial changes? You will need to use Aggr() function to get this fixed. Exact expression would be rather difficult to provide because of the complexity, but if you can provide a sample, we might be able to help</P></BODY></HTML> Tue, 20 Sep 2016 20:13:15 GMT https://community.qlik.com/t5/QlikView/problem-with-rangesum/m-p/1188965#M886220 sunny_talwar 2016-09-20T20:13:15Z