6 Replies Latest reply: Mar 3, 2015 1:49 PM by Staffan Johansson RSS

    Distribute values from begin to and end contract date??

      CustomerTotal (rental) value for 1 month Begin contract dateEnd Contract Date
      1500031-12-201431-12-2015
      220031-1-201531-12-2016

       

      The above is the information that I have in Qlikview at the moment.

       

      What I want is the following:

       

      Customer Rental Sum monthDate
      1500031-12-2014
      1500031-1-2015
      15000etc
      1500031-12-2015
      220031-1-2015
      2

      200

      etc
      220031-12-2016

       

      Who can help me out?