5 Replies Latest reply: Nov 12, 2013 5:56 AM by Michel Drets RSS

    Replace #N/A cells with 0 when importing from Excel

      Hello all, I searched first, but I could not find this question asked here before:

       

      When I am importing data from Excel, certain cells contain the value #N/A instead of 0 (zero) which blocks other calculations in Qlikview.

       

      Is there a way to replace the #N/A with the integer 0 via the script in QlikView?

       

      Thanks a lot for any help!

       

      Regards,

       

      J