Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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