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

    aggr

    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