Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Need a running sum

From 2 tabels (Bank account and Forecast)  I have the following information.

           

Date (T1 and T2)Current Account Balance (T1)Forecast (T2)Running Sum
01/0110050100
02/0111090110
03/0100110
04/01050160
05/010- 40120
06/0100120
07/01080200

I need a running sum (03/01) from the moment the last Current Balance is know.  How can this be calculated?

Thanks

John

1 Solution

Accepted Solutions
sreenivas
Contributor III

Re: Need a running sum

Hi

Please find the attached file hope it helps you requirement.

4 Replies
sreenivas
Contributor III

Re: Need a running sum

Hi

Please find the attached file hope it helps you requirement.

Not applicable

Re: Need a running sum

Thanks very much. This works !!

Not applicable

Re: Need a running sum

Hi,

This workds. Thanks very much for your help.

Not applicable

Re: Need a running sum

Hi,

Try this sample file

Best of luck

Community Browser