Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

How to exclude certain values from a load

Hi,

I've got load fields with values I want to exclude eg "#Null!","9", etc.  Can one do this for individual fields?

Any help thanks,

Racine62

1 Solution

Accepted Solutions
Highlighted

Re: How to exclude certain values from a load

1)

Select * from ...

Where Field1 <> null and Field1 <>'9' and Field2 <> '4'

Load data wher Field1 is not null and will never contain value 9 and field2 will never contain value 4

2 Replies
Highlighted

Re: How to exclude certain values from a load

1)

Select * from ...

Where Field1 <> null and Field1 <>'9' and Field2 <> '4'

Load data wher Field1 is not null and will never contain value 9 and field2 will never contain value 4

Not applicable

Re: How to exclude certain values from a load

Thanks for this,

Regards,

Racine62

Community Browser