Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
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