Set Analysis : OR Conditions

sanketkhunte — Wed, 09 Dec 2015 09:35:09 GMT

Hi there,

Could you please let me know how can we handle below DB where clause in Set Analysis -:

WHERE

SC_START_DATE < V_END_DATE + 1 AND

(

SC_ENABLED_STATE = 1 OR

(SC_LAST_CANCELLED_DATE IS NULL AND SC_ENABLED_STATE = 1) OR

SC_LAST_CANCELLED_DATE <= SC_START_DATE OR

SC_LAST_CANCELLED_DATE >= V_END_DATE + 1 OR

(SC_LAST_CANCELLED_DATE IS NULL AND SC_ENABLED_STATE <> 1 AND SC_MODIFY_DATE >= V_END_DATE + 1)

)

V_END_DATE is input from user.

Really appreciate your input on this.

Thanks

Sanket

topic Set Analysis : OR Conditions in QlikView