Discussion board where members can get started with QlikView.
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 - firstname.lastname@example.org - 18356-2
2 - email@example.com - 19036-2
3 - firstname.lastname@example.org - 18356-2
4- email@example.com - 15352-6
5- firstname.lastname@example.org - 13425-4
6- email@example.com - 13425-5
And I need to count only when the email and Id person are unic.
The result should show count = 2
The question must be contradicting itself. Could you please simplify the question, and which values do you need to see and why?
@jonnaamb please your help!
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.