Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a set of data like below:-
I have to display the name of, max of this sales office in a KPI, where most cases were registered,How to write expression for this?
In this example suppose, Uttar Pradesh SO II has max of 4 cases, so it should display 'Uttar Pradesh SO II'.
FirstSortedValue([Sales Office],-AGGR(count([Sales Office]),[Sales Office]))
View solution in original post
Your dataset example seems to be missing one record for Uttar Pradesh SO II.
Add in a record for Uttar Pradesh SO II into the inline table and you should get the result.
Thank you very much, it's working as expected.