topic Cumulative Sum Over Periods with ValueList in QlikView https://community.qlik.com/t5/QlikView/Cumulative-Sum-Over-Periods-with-ValueList/m-p/910830#M985964 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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. </P><P>I thought about using aggr function but couldn't figure out how to use the&nbsp; Valuelist as a dimension in the aggr. Not even sure if that will work.&nbsp; </P><P></P><P>Any suggestion/tip is appreciated. </P><P></P><P>Thanks.</P></BODY></HTML> Tue, 04 Aug 2015 23:06:33 GMT 2015-08-04T23:06:33Z Cumulative Sum Over Periods with ValueList https://community.qlik.com/t5/QlikView/Cumulative-Sum-Over-Periods-with-ValueList/m-p/910830#M985964 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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. </P><P>I thought about using aggr function but couldn't figure out how to use the&nbsp; Valuelist as a dimension in the aggr. Not even sure if that will work.&nbsp; </P><P></P><P>Any suggestion/tip is appreciated. </P><P></P><P>Thanks.</P></BODY></HTML> Tue, 04 Aug 2015 23:06:33 GMT https://community.qlik.com/t5/QlikView/Cumulative-Sum-Over-Periods-with-ValueList/m-p/910830#M985964 2015-08-04T23:06:33Z Re: Cumulative Sum Over Periods with ValueList https://community.qlik.com/t5/QlikView/Cumulative-Sum-Over-Periods-with-ValueList/m-p/910831#M985965 <HTML><HEAD></HEAD><BODY><P>I doubt you would be able to use <SPAN style="font-size: 13.3333330154419px;">ValueList </SPAN>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</P></BODY></HTML> Tue, 04 Aug 2015 23:09:23 GMT https://community.qlik.com/t5/QlikView/Cumulative-Sum-Over-Periods-with-ValueList/m-p/910831#M985965 sunny_talwar 2015-08-04T23:09:23Z