Need to calculate a Accumulated Column

[muhammedraleen]

Hi All,

I have attached a sample dataset (Ledger Account), in which I have highlighted a column in yellow, which is the column to be achieved in Qlik Sense.

Can anyone refer to that, give me a solution. I have attached below a screenshot also.

What Should Happen -> In the balance column, we have the amount of each document value, In a new column, first line should show (Closing balance of 2023-balance column first line doc value), and in second line it should show, (new column first line value-balance column second line doc value), and it should till last row.

Note: - This is only one ledger account dataset, there are multiple ledges.

[F_B]

Hi @muhammedraleen ,

this previous question might be what you are looking for:

Solved: Cumulative Sum in QlikSense Expression using Range... - Qlik Community - 1691470

[muhammedraleen]

Hi @F_B ,

The link you posted above didn't fulfill my requirement.

Anyways, thank you for your time.