5 Replies Latest reply: Mar 19, 2013 5:24 AM by dbuijsman RSS

    Excell cells are blank instead of NULL

      Hi,

       

      When i load data from excel and the cell is empty it shows in Qlikview a blank cell instead of being null.

      In my application im using a pivot table with the expression IF(ISNULL(Date1), today() - DATE, '0'), this won't work, there is no outcome in my pivot table.

       

      Does somebody know how i can solve this?