Qlik receives a report from several fields

Question

I have been combing the network for more than an hour and cannot find what I need.

I have two columns that contain the name of the person; Contactand Created By. Both are in the same format.

Basically I need to count the different BOTH values ​​of these columns together. for example, the Name may appear in each data column several times, but I only need one name counted once.

I tried using below, but it returns a number greater than the actual different values ​​between both columns.

=Sum(Aggr(Count(Distinct [Created By]),[Contact])) 

also tried this and the same number returned to me as above.

=Count(Distinct [Contact] & [Created By])

Thanks in advance!

Answer 1

, - :

count(distinct Contact) + count({$<[Created By]-=p(Contact)>} distinct [Created By])

, uniques Contact uniques Created By, Created By Contact.