Reallocation

[Anonymous]

HI All,    

I'm fairly new to QlikView and wonder if below reallocation approach can be done in qlikview. I have two tables and only need 'cash out flows' amount sum up to contribution amount. Whatever remains from 'Cash Out Flows' amount will be carry over to next contribution date. Please see  "Expected Output" piece below.    

Table of Contribution
Date	Contribution
1/31/2015	1000
2/28/2015	2000
3/31/2015	500
Total	3500

Table of Cash Out Flows
Date	Cash Out Flows
1/3/2015	300
1/4/2015	800
2/2/2015	700
2/25/2015	500
3/18/2015	600
3/26/2015	600
Total	3500

Expected   Output
	Cash Flows	Date(Contribution)	Contribution
	300	1/31/2015	1000
	700	1/31/2015	1000
Remainder from 1/14/15 - '800'	100	2/28/2015	2000
	700	2/28/2015	2000
	500	2/28/2015	2000
	600	2/28/2015	2000
only need 100 from 3/26/15   '600'	100	2/28/2015	2000
	500	3/31/2015	500
Total	3500

Any information will be greatly appreciated!