topic Re: Key matches in both tables in QlikView https://community.qlik.com/t5/QlikView/Key-matches-in-both-tables/m-p/120735#M602423 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try this:</P><P></P><P><STRONG>=sum(if( (len(Trim(C))=0 and len(trim(D))=0) or (len(Trim(A))=0 and len(trim(B))=0), 0, 1))</STRONG></P></BODY></HTML> Fri, 19 Oct 2018 15:02:41 GMT YoussefBelloum 2018-10-19T15:02:41Z Key matches in both tables https://community.qlik.com/t5/QlikView/Key-matches-in-both-tables/m-p/120734#M602422 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I try to find out, how often my key matches in both tables.</P><P></P><P>Please see attached sample file.</P><P></P><P>Is there a possibility to work with the where exists function? And / or do you have other ideas how to solve this question?</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 19 Oct 2018 14:38:10 GMT https://community.qlik.com/t5/QlikView/Key-matches-in-both-tables/m-p/120734#M602422 chriys1337 2018-10-19T14:38:10Z Re: Key matches in both tables https://community.qlik.com/t5/QlikView/Key-matches-in-both-tables/m-p/120735#M602423 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try this:</P><P></P><P><STRONG>=sum(if( (len(Trim(C))=0 and len(trim(D))=0) or (len(Trim(A))=0 and len(trim(B))=0), 0, 1))</STRONG></P></BODY></HTML> Fri, 19 Oct 2018 15:02:41 GMT https://community.qlik.com/t5/QlikView/Key-matches-in-both-tables/m-p/120735#M602423 YoussefBelloum 2018-10-19T15:02:41Z