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

       

       

       

       

       

      Regards

      Deepanshu