0 Replies Latest reply: Apr 30, 2015 2:56 PM by Frankie Liu RSS

    Reallocation

    Frankie Liu

      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!