multiple Or-And conditions in one expression

[Prachi_Pradip_Kulkarni]

Hi, 

I am trying to implement following if condition in set analysis:

IF condition: count(distinct if(R1='YES' or R2='YES' or R3 ='YES') and Flag=1),ID)

set analysis: count(distinct {<{R1='YES' + R2='YES' + R3 ='YES'},Flag=1>}ID)

also tried        count(distinct {<R1='YES',Flag=1 + R2='YES',Flag=1 + R3 ='YES',Flag=1}ID)

But it's Not working...

What can I do to solve this with set analysis?

Thank you in advance.

Best regards

[brunobertels]

Hi 

Try this 

count(distinct {<R1={'YES'}> + <R2={'YES'}> + <R3 ={'YES'}>,Flag={1}>}ID)

[stevejoyce · Accepted solution]

@brunobertels i dont think that's correct syntax where you put that flag.

count(distinct {<R1={'YES'}> + <R2={'YES'}> + <R3 ={'YES'}> * <Flag={1}>}ID)

or

count(distinct {<R1={'YES'}, Flag={1}> + <R2={'YES'}, Flag={1}> + <R3 ={'YES'}, Flag={1}> }ID)

[Prachi_Pradip_Kulkarni]

Hi brunobertels,

Thanks for reply

Not working for me

[AshutoshBhumkar]

Or maybe in your way

 if(R1='YES' or R2='YES' or R3 ='YES' and Flag=1, Count(ID) )

[Prachi_Pradip_Kulkarni]

Thank You @stevejoyce ,

It's Working!🙂