Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

dajjan81
New Contributor II

Running total Rolling12 with ingoing balance

Hi,

anyone who knows how to make this SET-analysis with the QVC-variables?

I think this does what I want but there must be a better way:

"

rangesum(after(sum($(vSetRolling12) MyValue),0,12))

//+ IB

+

sum({<Year=, [Year-Month]=, Month=, Date = {"<$(=min($(vSetRolling12) Date))"}>}total MyValue)

"

Regards

David

Community Browser