4 Replies Latest reply: Jan 4, 2013 12:57 AM by chandu k RSS

    How to Change NULL in the current date?

      Hello,

       

      I'm using an oracle database (Im using Qlikview personal edition). Im loading columns filled with a date, what i want is to load the current date where the cel is NULL.

      Here is a part of the database:

       

      DATE1DATE2DATEE3
      17-12-2012 0:0020-12-2012 0:0020-12-2012 0:00
      19-12-2012 0:0019-12-2012 0:0019-12-2012 0:00
      20-12-2012 0:0031-12-4000 0:00
      24-12-2012 0:0031-12-4000 0:00
      27-12-2012 0:0031-12-4000 0:00
      27-12-2012 0:0030-12-2012 0:0030-12-2012 0:00
      27-12-2012 0:0031-12-4000 0:00
      31-12-2012 0:0031-12-4000 0:00

       

      Im using a chart with the following expression SUM(DATE3 - DATE1 +1). Does somebody now how i can load the NULL's as the current date, so that it will load today as 03-01-2013 and tomorrow as 04-12-2013 (when i refresh my script) etc.?