Reallocation

Anonymous — Mon, 27 Apr 2015 20:35:01 GMT

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!

topic Reallocation in QlikView

Reallocation