https://community.qlik.com/t5/App-Development/Running-sum-help/m-p/1954448#M78716 <P>Hi,</P> <P>solved working on backend side!</P> <P>Thanks</P> Tue, 12 Jul 2022 10:42:16 GMT avenino 2022-07-12T10:42:16Z https://community.qlik.com/t5/App-Development/Running-sum-help/m-p/1954168#M78689 <P><SPAN class="case-view-details-data">Hi,<BR />I need some help with a measure: I'm trying to implement a running sum, so that every month of year shows the sum of itself and the previous ones.</SPAN></P> <P><SPAN class="case-view-details-data">I tried with:<BR />RANGESUM(ABOVE(TOTAL $(SelMeasure), 0, YTD))<BR />where $(SelMeasure) contains the meas I want to sum and YTD the number of month to sum: it works, but I cannot have the right total.</SPAN></P> <P><SPAN class="case-view-details-data"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="running_sum_no_total.png" style="width: 951px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/83834iAF66BFFB44570E41/image-size/large?v=v2&amp;px=999" role="button" title="running_sum_no_total.png" alt="running_sum_no_total.png" /></span></SPAN></P> <P><SPAN class="case-view-details-data"><BR />So I tried adding another aggregation:<BR />SUM(AGGR(RANGESUM(ABOVE(TOTAL $(SelMeasure), 0, YTD)), PDVID, GIROVISITAID))<BR />but I got a strange result.</SPAN></P> <P><SPAN class="case-view-details-data"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="running_sum_with_aggr.png" style="width: 761px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/83835i7DA659FE0BEC2812/image-size/large?v=v2&amp;px=999" role="button" title="running_sum_with_aggr.png" alt="running_sum_with_aggr.png" /></span></SPAN></P> <P><SPAN class="case-view-details-data"><BR />&nbsp;<BR />What am I doing wrong? <BR />&nbsp;<BR />Thank you in advance!</SPAN></P> <P>&nbsp;</P> <P><SPAN class="case-view-details-data">Andrea</SPAN></P> Mon, 11 Jul 2022 16:28:01 GMT https://community.qlik.com/t5/App-Development/Running-sum-help/m-p/1954168#M78689 avenino 2022-07-11T16:28:01Z https://community.qlik.com/t5/App-Development/Running-sum-help/m-p/1954448#M78716 <P>Hi,</P> <P>solved working on backend side!</P> <P>Thanks</P> Tue, 12 Jul 2022 10:42:16 GMT https://community.qlik.com/t5/App-Development/Running-sum-help/m-p/1954448#M78716 avenino 2022-07-12T10:42:16Z