Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

fanko1225
Not applicable

Reallocation

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
DateContribution
1/31/20151000
2/28/20152000
3/31/2015500
Total3500

Table of Cash Out Flows
DateCash Out Flows
1/3/2015300
1/4/2015800
2/2/2015700
2/25/2015500
3/18/2015600
3/26/2015600
Total3500

Expected
  Output
Cash FlowsDate(Contribution)Contribution
3001/31/20151000
7001/31/20151000
Remainder from 1/14/15 - '800'1002/28/20152000
7002/28/20152000
5002/28/20152000
6002/28/20152000
only need 100 from 3/26/15
  '600'
1002/28/20152000
5003/31/2015500
Total3500

Any information will be greatly appreciated!