Discussion Board for collaboration on QlikView Scripting.
I've a field name "UserLocation".
and data is Bangalore
' ' this is null value it contains nothing.
I want to convert, this empty value into "Not-defined" value.
I've tried the following one
pick(wildMatch(UserLocation,'* *','Bangalore','Chennai','Hyderabad'),'Not-defined','Bangalore','Chennai','Hyderabad') as UserLocation
but still I can't see Not-defined data in the UserLocation field.
Need Help on this?
Go to Solution.
if(IsNull(UserLocation),'Not-defined',UserLocation) as UserLocation
if(len(trim(UserLocation))=0,'Not-Defined',UserLocation) as UserLocationNew,