How to count by two distinct variables

[jaarroyl]

Hello, I need your help guys to know how could i count in a table by 2 distinct.

I have this table:

Id - Mail - Id person

1 - a@a.cl - 18356-2

2 - a@a.cl - 19036-2

3 - b@c.cl - 18356-2

4- cd@cd.cl - 15352-6

5- fg@fg.cl - 13425-4

6- fg@fg.cl - 13425-5

And I need to count only when the email and Id person are unic.

The result should show count = 2

4- cd@cd.cl - 15352-6

5- fg@fg.cl - 13425-4

Best,

[jonnaamb]

Hello Jaarroyl,

The question must be contradicting itself. Could you please simplify the question, and which values do you need to see and why?

Regards

Ambareesh

[jaarroyl]

I think you are right about the question, but I think I have putted what I want to obtain.

I need to filter in database all the rows that have duplicates in email and id person. Data are quotations from a website and we need to achieve unic seasons for each person.

Thanks

[jaarroyl]

@jonnaamb please your help!

Best,

[jonnaamb]

Hi Jaarroyl, 

Whenever we are using Qlik for unique values, it is ideal use Only() function for better performance as it removes duplicates.

However, in our scenario - depending up on the dimensions, we can see different combinations of unique values. 

1. Please go through this link first - How To Use ONLY() function in QlikView

2. For our scenario, I've tested and got the attached results. Hope it helps.

Cheers,

Ambareesh