11 Replies Latest reply: Aug 28, 2017 9:08 AM by Sunny Talwar RSS

    Accumulated SUM of Revenue, Comparing two or more years

    Nicolai Lund

      Hi,

       

      In qlikview it is really easy, but in Qlik Sense Cloud I'm struggling to accumulate revenue month by month, and having more than one year in the Line Chart.

       

      I have found that rangesum( above(total sum(revenue),0,rowno(total))) accumulates perfectly when I'm only selection one year. But if I remove the selection and include 3 years, they show as three different colors (which is perfect) but accumulate wrongly. I need each year to start the year from zero in the accumulation.

       

      The reason for the yellow line being so short is that we have no revenue data prior to September 2015. Blue line is 2017, where August is latest data I have.

       

      Clip.JPG