Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
avenino
Partner - Contributor
Partner - Contributor

Running sum help

Hi,
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.

I tried with:
RANGESUM(ABOVE(TOTAL $(SelMeasure), 0, YTD))
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.

running_sum_no_total.png


So I tried adding another aggregation:
SUM(AGGR(RANGESUM(ABOVE(TOTAL $(SelMeasure), 0, YTD)), PDVID, GIROVISITAID))
but I got a strange result.

running_sum_with_aggr.png


 
What am I doing wrong?
 
Thank you in advance!

 

Andrea

Labels (1)
1 Reply
avenino
Partner - Contributor
Partner - Contributor
Author

Hi,

solved working on backend side!

Thanks