topic Re: Set Analysis with Variable in QlikView

Set Analysis with Variable

Tue, 22 Apr 2014 17:17:55 GMT

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

Re: Set Analysis with Variable

MK_QSL — Tue, 22 Apr 2014 17:23:11 GMT

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

Re: Set Analysis with Variable

pgrenier — Tue, 22 Apr 2014 17:25:34 GMT

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

Re: Set Analysis with Variable

Tue, 22 Apr 2014 17:32:26 GMT

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

Re: Set Analysis with Variable

Tue, 22 Apr 2014 17:33:02 GMT

Hi Philippe,

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

Thanks!

Jordan

Re: Set Analysis with Variable

MK_QSL — Tue, 22 Apr 2014 17:34:05 GMT

Can you load sample file?

Re: Set Analysis with Variable

pgrenier — Tue, 22 Apr 2014 19:03:45 GMT

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