Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
JonnyPoole
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
datanibbler
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

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi Stuart,

PFA

hope it helps

JonnyPoole
Employee
Employee

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

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

Not applicable
Author

works perfect - thanks

Not applicable
Author

Thanks - I can see this would be of use also

Not applicable
Author

Thanks  - i might use this for a later iteration