Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Sunil_Kenth
Former Employee
Former Employee

Help with expression syntax

Hi - simple query here for you experts!

I want the exclude data through the load script.  I can do it for one value:

WHERE NOT MARKET = 'INTERCOMPANY' ;

this works fine, but if want to exclude multiple then i am trying to use the following:

WHERE NOT MARKET = 'INTERCOMPANY' OR 'EXPORT'; 

But this doesnt work - do you know what the right syntax is?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Just  'EXPORT' will not return a Boolean or equivalent representation, I believe.

Try

where not (MARKET = 'INTERCOMPANY' or MARKET = 'EXPORT');

maybe your could use IN (depending on your database used, like

where not MARKET in ('INTERCOMPANY','EXPORT);

regards,

Stefan

View solution in original post

4 Replies
its_anandrjs

Hi,

You have to use some thing like

WHERE NOT MARKET  =  Match(MARKET, 'INTERCOMPANY' , 'EXPORT' );

HTH

Rgds

Anand

swuehl
MVP
MVP

Just  'EXPORT' will not return a Boolean or equivalent representation, I believe.

Try

where not (MARKET = 'INTERCOMPANY' or MARKET = 'EXPORT');

maybe your could use IN (depending on your database used, like

where not MARKET in ('INTERCOMPANY','EXPORT);

regards,

Stefan

marcohadiyanto
Partner - Specialist
Partner - Specialist

Hi,

you can try this.

WHERE (MARKET <>'INTERCOMPANY') AND (MARKET <>'EXPORT')

regards,

Marco

Sunil_Kenth
Former Employee
Former Employee
Author

Thanks - they were all helpfull responses but swuehi is the winner