Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

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

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