Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Former Employee
Former 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
Former Employee
Former 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