Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
Count(DISTINCT {<Test_Family = {'abc', 'abcd'}, High_Risk = {'Yes'}>} A_ID)
May be this:
Count(DISTINCT {<Test_Family = {'abc', 'abcd'}, High_Risk = {'Yes'}>} A_ID)
It worked Sunny.
Thank you
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
I don't see anything wrong here. What is the error that you are seeing?
I got decreased count
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?
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
So is this all resolved now?
Yes sunny. Thank you