How to Exclude many values using where statement?

[#1]

Can anyone please help me..I want to exclude these two documents type from my Qlikview file. I am using this where statement but its not working

Where  DOCUMENT<>'Ziplock' and DOCUMENT<>'TYPE F';

Where  DOCUMENT<>'Ziplock' and Where DOCUMENT<>'TYPE F';

Do let me know if you have any sugessitions because both of the above is not working.

Regards,

Vikas

[swuehl · Accepted solution]

I don't see anything wrong with your first statement:

LOAD * Where DOCUMENT<>'Ziplock' and DOCUMENT<>'TYPE F';

LOAD recno() as ID, DOCUMENT INLINE [

DOCUMENT

TYPE F

TYPE f

Ziplock

ZIPLOCK

];

returns 2nd and 4th value. What do you get?

[nagaiank]

Try replacing 'and' with 'or' in the Where clause or use the following Where clause:

Where Match(DOCUMENT,'Ziplock','TYPE F') = 0

[#4]

Sorry I forgot its case sensitive...now its working fine..thanks