4 Replies Latest reply: Apr 5, 2018 10:50 PM by Kenneth Holden RSS


    Kenneth Holden

      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