topic Where clause in QlikView

Where clause

Wed, 25 Mar 2015 12:38:52 GMT

Hi Team,

I want to remove rows that contain name field which is either null or blank or unknown or - during load time.

I tried to use where clause in the script editor while loading the table.

all the condition works fine except '-'

Where [Student Name] <> '-' or [Student Name]= ' ' or [Student Name] = 'Unknown' or [Student Name]= 'null' ;

please guide me for the same.

Regards,

Priyanka

PrashantSangle — Wed, 25 Mar 2015 12:42:05 GMT

Hi,

Try

Where not wildmatch([Student Name],' ','Unknown','null','-')

Regards

Wed, 25 Mar 2015 12:42:36 GMT

Try with this

where not isnull( [Student Name ]) or [Student Name ] = 'Unknown' or len(trim([Student Name ])) <> 0

Wed, 25 Mar 2015 12:42:44 GMT

Hi Priya, For '-' try to: Where not IsNull([Student Name])

Wed, 25 Mar 2015 12:46:14 GMT

Thanks Francisco

It worked