Display result based on formula on a different field

[EGilbert]

I have a table with a number of fields  For the example lets call on Value and it is numeric.  Another field is a string and call it name and lastly another string called country.  I would like to display in a text box The name associated with the lowest value in the value field.  There will be a list box where the user can select a country which will change the results.  How do I write that expression?

[Lisa_P]

This is normal behaviour in QlikView.  Create a text object, in the Text on the general tab use your min expression

eg =Min(Value)

as you select Country, this will change to show the min Value for that country

[EGilbert · Accepted solution]

Thanks for the suggestion.  This would work to return the min value for the selected country but that is not quite what I need.  I need to return the value in the name field associated with the min value.  I did get it to work using the below expression

=concat( {<[Value]={"$(=min([Value])"}>} DISTINCT [Name])

This appears to be working but I am not sure if there is a better way to accomplish my desired results