Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Count if distinct

Please advise,

                                     I have three columns A & B & C

In A, there is a list of areas, in B there are lists of users, in C there are lists of groups that user can be a part of.

I need a KPI to show the count of distinct users if I choose a particular area.

 

Kind Regards for your help

Patman

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Count if distinct

Have you tried - Count(Distinct B) ?                        // Assuming B column is users

View solution in original post

2 Replies
Highlighted
MVP
MVP

Re: Count if distinct

Have you tried - Count(Distinct B) ?                        // Assuming B column is users

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Count if distinct

🙂 much appreciated 🙂