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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
dajjan81
Contributor II
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

0 Replies