topic Re: Set Analysis help in QlikView

Set Analysis help

hopkinsc — Wed, 04 Feb 2015 10:59:35 GMT

Hi all,

i need some help with set analysis syntax, it should be straight forward but i cant seem to get it to work.

i am trying to count an ID field but i only want to count the ID's where 2 other fields match.

count(distinct Contact_ID)

where campaignID=contactcampaignID

these 2 fields are in different tables

Can anyone help please?

jonathandienst — Wed, 04 Feb 2015 11:01:30 GMT

This should do it:

=Count(Distinct If(campaignID=contactcampaignID, Contact_ID)

HTH

Jonathan

PrashantSangle — Wed, 04 Feb 2015 11:05:34 GMT

Hi,

missing closing bracket.

=Count(Distinct If(campaignID=contactcampaignID, Contact_ID))

Regards

hopkinsc — Wed, 04 Feb 2015 11:08:03 GMT

bracket missing from the end but it works thanks!

jonathandienst — Wed, 04 Feb 2015 11:25:40 GMT

No syntax check in the post editor

PrashantSangle — Wed, 04 Feb 2015 11:32:31 GMT

Heheheeee

Got a bug