Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

chriys1337
Contributor II

Key matches in both tables

Hello,

I try to find out, how often my key matches in both tables.

Please see attached sample file.

Is there a possibility to work with the where exists function? And / or do you have other ideas how to solve this question?

Thanks!

1 Reply
YoussefBelloum
Esteemed Contributor

Re: Key matches in both tables

Hi,

try this:

=sum(if( (len(Trim(C))=0 and len(trim(D))=0) or (len(Trim(A))=0 and len(trim(B))=0), 0, 1))