Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cumulative Sum Over Periods with ValueList

Hi,

I'm trying to sum the running accumulated balance over periods in a ValueList Dimension (please see the attached sample file). When using the RangeSum in other cases it works perfectly. But maybe because the dimensions are the Valuelist itself in addition to the MonthYear dim so that adds a bit complexity.

I thought about using aggr function but couldn't figure out how to use the  Valuelist as a dimension in the aggr. Not even sure if that will work. 

Any suggestion/tip is appreciated.

Thanks.

1 Reply
sunny_talwar

I doubt you would be able to use ValueList in aggregate's dimension. An alternative to ValueList could be to use an Inline table which can then be referred to in the aggregate dimension