Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Where clause

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

1 Solution

Accepted Solutions
Not applicable

Re: Where clause

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

4 Replies

Re: Where clause

Hi,

Try

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Not applicable

Re: Where clause

Try with this

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

Not applicable

Re: Where clause

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

Not applicable

Re: Where clause

Thanks Francisco

It worked

Community Browser