3 Replies Latest reply: May 28, 2013 4:26 PM by Kevin Pinto RSS

    NullAsValue not working?

    Kevin Pinto

      I have some very straightforward code that should work but simply doesn't:

      NULLASVALUE *;
      SET NullValue ='NA' ;
      LOAD
      *
      FROM
      MyFile.qvd
      (qvd); 
      

       

      The code executes without errors as shown in the script:

       

      05/28/2013 11:20:51 AM: 0034  NULLASVALUE *
      05/28/2013 11:20:51 AM: 0035  SET NullValue ='NA' 
      05/28/2013 11:20:51 AM: 0038  LOAD
      05/28/2013 11:20:51 AM: 0039   *
      05/28/2013 11:20:51 AM: 0058  FROM
      05/28/2013 11:20:51 AM: 0059  MyFile.qvd
      

       

      But it has no effect whatsoever if you look at the attached picture.

       

      What am I doing wrong?  I have exactly the same problem on two different computers, running QlikView 11.00 SR2 and 11.20 SR1.