RangeSum not impacted by filtering on abscissa dimension

[reivax31]

Hi Qlikers,

I used rangesum to have a cumulative sum on my chart with in abscissa my date field (MonthYear). but when I select a range of date the values will change and start from the first date selected.

function is like this:

rangesum( above(

-sum({$<

[Country]={'UK','US'},

>} [Sales])

,0,rowno()))

Thanks for your support

[marcus_sommer]

Maybe by adding the following:

rangesum( above(

-sum({$<

[MonthYear] =,

[Country]={'UK','US'},

>} [Sales])

,0,rowno()))

- Marcus

[sunny_talwar · Accepted solution]

and may be add this to only show the months selected

RangeSum(Above(-Sum({$<[MonthYear] =, [Country]={'UK','US'}>} [Sales]), 0, RowNo())) * Avg({<[Country]={'UK','US'}>} 1)

[reivax31]

Thanks Marcus and Sunny! it worked perfectly