Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count where ID's exist in one table but not another

Hi,

I have 2 tables loaded up in Qlikview

Client  -  This contains ALL clients

Communication - This contains all clients who have an email address

The one common field between the tables is ClientID.

Is there any way that I can use COUNT and Set Analysis to count the number of Client IDs that Exist in the Client table but DO NOT exist in the Communication table?

Thanks

Stu

1 Solution

Accepted Solutions
Employee
Employee

This should work, still tinkering to put it into 1 SET statement

=count( distinct ClientID) - count( DISTINCT  {$<Email={"*"}>} ClientID)

View solution in original post

6 Replies
Champion
Champion

Hi,

just

- LOAD those two tables like you did before

- LOAD a small table RESIDENT [All] with a WHERE NOT EXISTS([email_adress_table_ID])

- Join that to the table where you want that flag via the client_ID

HTH

Best regards,

DataNibbler

Partner
Partner

Hi Stuart,

PFA

hope it helps

Employee
Employee

This should work, still tinkering to put it into 1 SET statement

=count( distinct ClientID) - count( DISTINCT  {$<Email={"*"}>} ClientID)

View solution in original post

Not applicable

works perfect - thanks

Not applicable

Thanks - I can see this would be of use also

Not applicable

Thanks  - i might use this for a later iteration