topic Re: Match Function in QlikView

Match Function

MuraliPrasath — Tue, 31 May 2016 07:53:10 GMT

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?

Kushal_Chawda — Tue, 31 May 2016 07:56:24 GMT

try this

LOAD *,

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

.....

sasiparupudi1 — Tue, 31 May 2016 08:04:30 GMT

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

hth

Sasi