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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
pala_jagadeesh
Contributor III
Contributor III

Display matching count

There is three tables

Skype
abc@gmail.com;abc.d@gmail.com;d.abc@gmail.com
anu@gmail.com;anu.sree@gmail.com;sree.anu@gmail.com
asha@gmail.com;asha.d@gmail.com;d.asha@gmail.com
cone@gmail.com;cone.su@gmail.com;su.cone@gmail.com

 

Email
abc@gmail.com
anu.sree@gmail.com
d.asha@gmail.com
sesu@gmail.com

 

Mail
abc@gmail.com
anu.sree@gmail.com
d.asha@gmail.com
seema@gmail.com

 

Here  three mails  anu.sree@gmail.com, abc@gmail.com, d.asha@gmail.com present in three tables so i want matching count as  3

These  cone@gmail.com;cone.su@gmail.com;su.cone@gmail.com , sesu@gmail.com, seema@gmail.com are not matched in three tables so non-matching count  is 3

I want output like below

Matching Count Non-Matching Count
3 3
 
 
Labels (2)
0 Replies