Discussion Board for collaboration on QlikView Scripting.
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?
=sum(if( (len(Trim(C))=0 and len(trim(D))=0) or (len(Trim(A))=0 and len(trim(B))=0), 0, 1))