5 Replies Latest reply: Jul 12, 2018 5:12 AM by Hendri van de Bunte RSS

    Rolling sum with null values

    Hendri van de Bunte

      Hi,

       

      I am new to Qlik Sense but I try to do the following:

       

      ID:  Month:   Minutes:   Total minutes:

      1     Jan        10             10

      1     Feb        15             25

      1    March     null           25

      2     Jan        20             20

      2     Feb        null           20

      2    March     null           20

      3     Jan        5               5

      3     Feb        10           15

      3    March     15           30

      .....


      I tried this formula that I found in another post:


      rangeSum(Minutes) AS Cumulative . But this only returns 0 for the null values.


      How can I use this rolling sum with a break and nulls?


      Thanks for your help