3 Replies Latest reply: Oct 12, 2017 10:20 AM by xavier hemelaar RSS

    RangeSum not impacted by filtering on abscissa dimension

    xavier hemelaar

      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