Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
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?
regards
Paul
Give it a try with
IF(LEN(TRIM(Telephone)) = 0, 'not answered', Telephone) AS Telephone
HTH
Peter
Give it a try with
IF(LEN(TRIM(Telephone)) = 0, 'not answered', Telephone) AS Telephone
HTH
Peter
Instead of Telephone='' try
len(trim(Telephone))=0
(the trim can help you if there is a space ' ' there)
The NULL was not interpreted as a blank ('')
hope it helps,
Erich
Brilliant, worked perfectly - Thanks Guys