Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
acbishop2
Not applicable

String Associated with Min() of a Different Field

Hello All,

The concept seems simple, but I can't seem to get it to work.

I have a calculated field for speed (hours and minutes), and a string field with employee names. I need to have a KPI box that returns the string name of the specialist that has the lowest average speed for a particular task. Here's the sample data:

Specialist Sample Data.JPG

I'll have a KPI box for each Task, displaying the name of the Specialist that has the lowest average speed for each task. For example, in the VOE box, the name "Teresa" should be displayed because her average speed for the task is the lowest.

I appreciate the help in advance.

Aaron

1 Solution

Accepted Solutions
maxgro
Not applicable

Re: String Associated with Min() of a Different Field

maybe

=FirstSortedValue(Specialist, aggr(avg({$ <Task={'VOE'}>} Speed),Specialist,Task))

1 Reply
maxgro
Not applicable

Re: String Associated with Min() of a Different Field

maybe

=FirstSortedValue(Specialist, aggr(avg({$ <Task={'VOE'}>} Speed),Specialist,Task))