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?
- 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