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
