Value before Min Value

[Anonymous]

Hi

I have a list box with values in text , I need to display the value before minimum value , by usng minstring(column) I get the minimum value sorted alphabetically how do I get the value before that?

Thanks

[Anonymous]

oh ok .. thank you for the explanation , so there is no way that we could get the value I am looking for ?

[kaushiknsolanki]

It would be helpful if you share sample application with this data.

Regards,

Kaushik Solanki

[tamilarasu]

Kausik,

In that case, can we use like below.??

=MinString({<F1-={"$(=Minstring(Lower(F1)))"}>} Lower(F1))

But field values will be converted to lower case.

[kaushiknsolanki]

Hi,

Yes if you change the string into Lower Case it should work.

Regards,

Kaushik Solanki

[Anonymous]

Sure , Attached.

[kaushiknsolanki]

Hi,

The solution given by Tamil will work

=MinString({<[Group-Function] -= {"$(=Minstring([Group-Function]))"}>}lower([Group-Function]))

Regards,

Kaushik Solanki

[Anonymous]

Yes this works Thank you!, but I also have to display this value in the chart , so basically what I am trying to do is select Min value from group-function when the app open , so I have set this value in Open Triggers , I have the title of a chart to display the selected GroupFunction value with the below expression, but this does not display when I open the App , it only displays when I manually select the same value from the filter again.

=IF(GetFieldSelections([Group-Function])=[Group-Function],[Group-Function])

[kaushiknsolanki]

Kindly share the QVW file.

Regards,

Kaushik Solanki