Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=FirstSortedValue(Agent,-aggr(Count({<Department={'CE'},Period_seq={'$(=max(Period_seq))'}>}NPS),Agent))
Sachin
Bye..Njoy ur day
Sachin