set analysis "or" and "and" operators

[#1]

Hi,

can we write below expression in set analysis?

count(distinct if(((Test_Family= 'abc' or Test_Family = 'abcd') and High_Risk = 'Yes'), A_ID))

Thanks in Advance.

Thanks,

Rohini

[sunny_talwar · Accepted solution]

May be this:

Count(DISTINCT {<Test_Family = {'abc', 'abcd'}, High_Risk = {'Yes'}>} A_ID)

[#3]

It worked Sunny.

Thank you

[#4]

Hi Sunny,

When I add another condition for the same expression its not working. Can you help me with this.

Count(DISTINCT {$<Test_Family_2 = {'NIPT', 'NIPTMD'}, High_Risk_NIPT = {'Yes'}, Adjudicated = {1}>} Accession_ID)

Thanks,

Rohini. M

[sunny_talwar]

I don't see anything wrong here. What is the error that you are seeing?

[#6]

I got decreased count

[swuehl]

Isn't this what is expected? I mean, by adding another AND condition to the set analysis?

At most you would get the same count as before, but not more, right?

[#8]

Yes Stefan.

But I have same condition written in if condition and am comparing set expression results to the regular if condition results.

But now I checked with same and I got correct results. May be I mistaken with some other logic.

Thank you

[sunny_talwar]

So is this all resolved now?

[#10]

Yes sunny. Thank you