15 Replies Latest reply: Jun 7, 2016 8:12 AM by Deepanshu Chamoli RSS

    Running Total

    Deepanshu Chamoli

      Hello All


      Please tell me if it is possible or not in Qlik Sense.


      Need your help on urgent basis


      For calculating the running total I am using the below formula. It works perfectly fine for me


      rangesum(above(TOTAL sum(Cases),0,rowno(TOTAL)))


      The issue is that when I choose the particular month it shows only Current Month data. I want if the person filter out any month it sum all the data till current month

      For E.g. (Attached Snapshot)



      Suppose if I choose/Filter March 2014 it shows total 60. Currently it shows only 20

      Please advise