Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
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!   

0 Replies