Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
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

Highlighted
Partner
Partner

Hi Stuart,

PFA

hope it helps

Highlighted
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

Highlighted
Not applicable

works perfect - thanks

Highlighted
Not applicable

Thanks - I can see this would be of use also

Highlighted
Not applicable

Thanks  - i might use this for a later iteration