21 Replies Latest reply: Feb 11, 2017 5:10 AM by sachin duganavar RSS

    Top performer KPI  (rank aggregate) help

    Katie Rushforth

      Hi I'm struggling with an expression to identify a Top performer as a KPI measure in Qlik Sense.

       

      I'm using the current statement to identify the total count of NPS surveys:

       

      Count({$<Period_seq={$(=max(Period_seq))},Department = {'CE'}>} NPS)

       

      I want to identify which Agent has the highest score - with the result being the name of the Agent.

       

      I've tried various rank and aggregate commands in other discussion threads that have worked for others but I can't seem to be able to get it to work in this scenario.

       

      thanks