Solved: Set Analysis help - Qlik Community

hopkinsc · ‎2015-02-04

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 · ‎2015-02-04

Hi

This should do it:

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

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

jonathandienst · ‎2015-02-04

Hi

This should do it:

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

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

PrashantSangle · ‎2015-02-04

Hi,

missing closing bracket.

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

hopkinsc · ‎2015-02-04

bracket missing from the end but it works thanks!

jonathandienst · ‎2015-02-04

No syntax check in the post editor

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

PrashantSangle · ‎2015-02-04

Heheheeee

Got a bug

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Set Analysis help

Related Topics