Solved: How to display max of the value name in KPI - Qlik Community

abc_18 · ‎2019-12-11

Hello,

I have a set of data like below:-

Sales office

Uttar Pradesh SO

Gujarat SO

Delhi Haryana SO

Punjab Himachal SO

Kerala SO

Punjab Himachal SO

TAPSO

Uttar Pradesh SO

Uttar Pradesh SO II

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'.

Please suggest.

Arthur_Fong · ‎2019-12-11

Try this:

FirstSortedValue([Sales Office],-AGGR(
count([Sales Office])
,[Sales Office]))

Arthur_Fong · ‎2019-12-11

Try this:

FirstSortedValue([Sales Office],-AGGR(
count([Sales Office])
,[Sales Office]))

Arthur_Fong · ‎2019-12-11

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.

abc_18 · ‎2019-12-12

Hi Arthur,

Thank you very much, it's working as expected.

Regards

How to display max of the value name in KPI