Where statement issues

Mon, 20 Oct 2014 10:35:10 GMT

I am trying to exclude junk emails during my script, the statement ends in the following

Where (

`recipient-address`='administrator1@company.com' OR

`recipient-address`='administrator2@company.com

)

and (left(`sender-address`,3) <> '/O=' OR left(`sender-address`,3) <> 'EX:')

Group by msgid,`recipient-address`;

My problem is that there are still email addresses being included that should have been excluded (starting in /O= or EX:) - my recipient addresses are correct but they do not exclude the sender addresses?

Re: Where statement issues

Peter_Cammaert — Mon, 20 Oct 2014 11:24:10 GMT

In the sender-address part of the logical condition, change the OR in an AND. Neither one of them should appear.

topic Where statement issues in QlikView

Where statement issues

Re: Where statement issues