Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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