OR Condition in SetExpression

raju_salmon — Mon, 11 Jun 2018 06:42:05 GMT

Hi,

I have gone through existing threads and understand that we can use + sign in set analysis to achieve OR condition. But however i am not how to write a expression for below sql query.

WHERE

[Type] IN ('PN','CT')

AND

(Store In ('DL A','RCS') OR [SType] != 'N Support')

Can anyone help me?

Regards,

Raju S

Re: OR Condition in SetExpression

tresB — Mon, 11 Jun 2018 06:49:10 GMT

Try like:

Sum(

{<Type={'PN', 'CT'}>*(<Store={'DL A','RCS'}>+<SType-={'N Support'}>)}

Sales)

topic OR Condition in SetExpression in QlikView

OR Condition in SetExpression

Re: OR Condition in SetExpression