topic How to Exclude many values using where statement? in QlikView

How to Exclude many values using where statement?

Thu, 19 Jul 2012 15:27:31 GMT

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 — Thu, 19 Jul 2012 15:36:16 GMT

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 — Thu, 19 Jul 2012 16:32:07 GMT

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

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

Thu, 19 Jul 2012 16:37:52 GMT

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