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



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



      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...



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