Set Analysis with Variable

[#1]

Hello,

I am attempting to create an expressions that counts unique person_ids when the person_id is associated to 2 or more encntr_ids.

Thus far I have had no luck in creating this expressions. The variables  vCntPerson and vCntEncntr are simply just counting the unique person_ids and encntr_ids.

=count(Distinct{<$(=vCntPerson)={"$(= '=' & '1' & $(=vCntEncntr) '>=' & '2')"}>} PERSON_ID)

Any help would be appreciated.

Thanks in advance!

Jordan

[MK_QSL]

=count(Distinct{<$(=vCntPerson)={"=$(vCntEncntr)>=2"}>} PERSON_ID)

[pgrenier]

Hello Jordan,

I believe you may get the desired result with the following expression:

=Count({<PERSON_ID={“=Count(encntr_ids) > 1”}>} DISTINCT PERSON_ID)

Regards,

Philippe

[#4]

Hi Manish,

Thank you for your quick response, however I am getting an error in set modifier expression with a 'red line' under the second open '{'.

Not sure why it does not like it there.

Thanks!

Jordan

[#5]

Hi Philippe,

Thank you for your response, however  this expression returns a count of 0 for me.

Thanks!

Jordan

[MK_QSL]

Can you load sample file?

[pgrenier]

Hello Jordan,

There was a typo in the previous expression with one of the double quote characters. This version should work if you copy-paste:

=Count({<PERSON_ID={"=Count(encntr_ids) > 1"}>} DISTINCT PERSON_ID)

Regards,

Philippe