10 Replies Latest reply: Nov 23, 2016 6:13 AM by Sunny Talwar RSS

    Rangesum cumulative with 2 dimensions

    xavier hemelaar

      HI Qlikers,

      I'm bulding a chart with cumulative sum and 2 dimensions. I found a lot of usefull informations on Qlik Community but I'm not completely finish with my task.

      So I have a table with 3 dimensions. ID, Country, Month. So in my line chart I want to count my ID for each Country and do a cumulative sum for each month. So far I have this expression:

      RangeSum(above(TOTAL Count(ID),0,RowNo(TOTAL)))

      But my country are not treated individualy. How can I specify that I want only a rangesum for each country?

       

      Thanks for your help