Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER 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

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