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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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