topic Re: How to count by two distinct variables in QlikView

How to count by two distinct variables

jaarroyl — Sat, 16 Nov 2024 04:09:09 GMT

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,

Re: How to count by two distinct variables

jonnaamb — Fri, 15 Mar 2019 19:29:22 GMT

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

Re: How to count by two distinct variables

jaarroyl — Fri, 15 Mar 2019 20:02:18 GMT

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

Re: How to count by two distinct variables

jaarroyl — Mon, 18 Mar 2019 18:11:14 GMT

@jonnaamb please your help!

Best,

Re: How to count by two distinct variables

jonnaamb — Tue, 21 May 2019 13:21:48 GMT

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