SET Analysis - How to implement OR condition

Fri, 06 Dec 2013 17:12:03 GMT

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

Gysbert_Wassenaar — Fri, 06 Dec 2013 17:20:53 GMT

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)