1 Reply Latest reply: Dec 6, 2013 12:20 PM by Gysbert Wassenaar

# SET Analysis - How to implement OR condition

Hi - Here is a scenario where I need to perform 4 opetarions in OR condition

 Condition  # Condition 1 EFF_DT between FROM_DT and  TO_DT 2 TERM_DT between FROM_DT and TO_DT 3 FROM_DT between EFF_DT and TERM_DT 4 TO_DT between EFF_DT and  TERM_DT

COUNT({<MEM_GENDER = {'M'}, MEM_EFF_DT = {">=\$(=Date(vFromDate))"}*{"<=\$(=Date(vToDate))"},FLAG_ELIG_PERSON_KEY ={1}>}  DISTINCT PERSON_KEY)

Highlighted above has  first condition, I dont know how to implement rest 3 onditions in OR. Can someone pls help me?

• ###### Re: SET Analysis - How to implement OR condition

Something like this:

COUNT({<MEM_GENDER = {'M'}, MEM_EFF_DT = {">=\$(=Date(vFromDate))<=\$(=Date(vToDate))"},FLAG_ELIG_PERSON_KEY ={1}>

+

<MEM_GENDER = {'M'}, MEM_TERM_DT = {">=\$(=Date(vFromDate))<=\$(=Date(vToDate))"},FLAG_ELIG_PERSON_KEY ={1}>

+

<MEM_GENDER = {'M'}, MEM_TERM_DT = {">=\$(=Date(vFromDate))"}, MEM_EFF_DT = {"<=\$(=Date(vFromDate))"} ,FLAG_ELIG_PERSON_KEY ={1}>

+

<MEM_GENDER = {'M'}, MEM_TERM_DT = {">=\$(=Date(vToDate))"}, MEM_EFF_DT = {"<=\$(=Date(vToDate))"} ,FLAG_ELIG_PERSON_KEY ={1}>

DISTINCT PERSON_KEY)