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!