3 Replies Latest reply: May 11, 2011 10:13 AM by Paul Nockolds RSS

    Changing blank fields(cells) from an xls to <Not Answered>

    Paul Nockolds

      Hello

       

      I have an xls file with some blank cells such as this...

       

      MissingAnswers.jpg

      When i LOAD the data into QlikView i want to replace the blank cells with the text <Not Answered> which i have attempted to do like this...

       

           If(Telephone='','<Not Answered>',Telephone) as Telephone,
           If([Email Address]='','<Not Answered>',[Email Address]) as Email
      

       

      Sadly this is not working though and it just displays the '-' character like so...

       

      MissingAnswers2.jpg

      Any ideas why this is not working or is there a better way to do this?

       

      regards

      Paul