23 Replies Latest reply: Jun 12, 2016 2:48 AM by Deepanshu Chamoli RSS

    Running Total with filters

    Deepanshu Chamoli

      Hello All

       

      Please help in the below query of Qlik Sense,

       

      I have the six columns Active Date, CL, DI, MR, ACID and MR.

       

      I have calculated the Running total based on the ACID in the straight table on monthly basis in Qlik visualization as

       

      Running Total = RangeSum(Above(TOTAL Sum({1}Cases),0,rowno(TOTAL))) * Avg(1)

       

      But the issue is that when I use the filters as CI, DI and MR, the Running total is not changed at all.

       

      Can it is possible to change the formula so that it changes as per the filters?

       

      Also, I want a KPI which calculate the % as (Cases for particular month)/ Running total of particular month.

       

      I am not able to calculate the above using the below formula:

       

      KPI = Sum (Cases)/Sum ({<Active_Date = {"$(='<=' & Date (Max (Active_Date), 'M/D/YYYY'))"}>} ACID)

       

      Attached is the file for your reference.

       

       

       

      Please suggest & help

       

      stalwar1

       

      Regards

      Deepanshu