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.