topic Re: Display result based on formula on a different field in QlikView

Display result based on formula on a different field

EGilbert — Sat, 16 Nov 2024 18:43:23 GMT

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?

Re: Display result based on formula on a different field

Lisa_P — Wed, 29 Apr 2020 00:24:45 GMT

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

Re: Display result based on formula on a different field

EGilbert — Wed, 29 Apr 2020 11:49:24 GMT

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