Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

MuraliPrasath
Contributor II

Match Function

Hi,

I've a field name "UserLocation".

and data is           Bangalore

                              Chennai

                              Hyderabad

                              '                '      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?

1 Solution

Accepted Solutions
sasiparupudi1
Honored Contributor III

Re: Match Function

if(IsNull(UserLocation),'Not-defined',UserLocation) as UserLocation

hth

Sasi

2 Replies

Re: Match Function

try this

LOAD *,

if(len(trim(UserLocation))=0,'Not-Defined',UserLocation) as UserLocationNew,

.....

sasiparupudi1
Honored Contributor III

Re: Match Function

if(IsNull(UserLocation),'Not-defined',UserLocation) as UserLocation

hth

Sasi

Community Browser