Need urgent logic

[Mahamed_Qlik]

Hi All,

I need below below resulting table. Kindly help with logic:

	Opened	Closed	Result
November	3		3
December	4		7
January	14	1	20
February	283	183	120
March	559	556	123
April	447	418	152

Logic for Result column is -

Initially it needs to set as value 3 (hard coded ok), later it should be

Result column = Opened - closed +Result

Please help me what expression and variables need to set to get above table.

Best Regards,

Mahamed

[m_woolf]

Something like:

load

     *,

     Opened - Closed + peek('Result') as Result

from MyTable

order by Date;

[Anonymous]

rangesum() would be better? or?

[Mahamed_Qlik]

Hi,

I need this to be done on front end.

Because there is separate expression written for opened an closed column .

[Mahamed_Qlik]

Can you please give me expression?

[Anil_Babu_Samineni]

May be this?

For last column, I used full accumulate

[Anil_Babu_Samineni]

Or May be expression this?

Rangesum(Below(Sum(Opened)-Sum(Closed),0),Above(Sum(Opened)-Sum(Closed),1,RowNo()))