Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

aggr

count(Aggr(total distinct(AGENT_LAST_NAME),SUPERVISOR))

I am trying to get QLIKSENSE to find the TOTAL number of reps under a specific supervisor, vs the number of active reps under the supervisor; for example a supervisor may have 4 reps who write business this week but actually have a total of 10 reps, just 6 did nothing, I am looking for the total number of reps under a supervisor.

This expression is giving me a 0 result.

any help appreciated

1 Solution

Accepted Solutions
sunny_talwar

Where are you doing this? Why not create a straight table with  SUPERVISOR as dimension and Count(DISTINCT AGENT_LAST_NAME) as expression? Would it not give the count of all Agents?

View solution in original post

4 Replies
sunny_talwar

Where are you doing this? Why not create a straight table with  SUPERVISOR as dimension and Count(DISTINCT AGENT_LAST_NAME) as expression? Would it not give the count of all Agents?

Anonymous
Not applicable
Author

i do have a table and supervisor as dimension, but count distinct agent last name is giving me active reps not total reps on the supervisor team

Anonymous
Not applicable
Author

count(total distinct(AGENT_LAST_NAME))

this was original expression, but it gives me the total reps for entire business, not for each supervsior.

Anonymous
Not applicable
Author

THIS Was working, sorry, i should shut my mac off and relax, I am not seeing the forest for the trees tonight.

Thank you for your time.