Running Total with filters

[Anonymous]

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

[Anonymous]

Please find the attached screenshot of the visualization

Might be it help

[sunny_talwar]

I am unable to open the .qvf. It throws an error

[Anonymous]

So Sorry sir.. Can you guide me how to store the data in qvf.

I am able to load it in qvd as follows:

Running_Total:

LOAD

    PGLD as Active_Date,

    CLN,

    DIN,

    MAN,

    ALID

FROM [lib://Files/AT.xlsx]

(ooxml, embedded labels, table is Sheet1);

OUTER JOIN

LOAD

    CCD as Active_Date,

    CIN as CLN,

    DIN,

    MAN,

    ACLID

FROM [lib://Files/CT.xlsx]

(ooxml, embedded labels, table is Sheet1);

STORE Running_Total INTO [lib://Files/Active.qvd](qvd);

[Anonymous]

Sir are you able to open the QVD file