Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, All! Anyone ever notice that when you make a selection or de-select a value in a List Box, the available values re-sort themselves? Has anyone figured out a way to make the sort order of the available values static, such that the values do not dynamically sort when you make a selection, but always remain in the same order?
Thanks for the responses, all. Unchecking Sort by State does not solve the problem. I don't want my list of values to re-sort at all when I select/de-select a value.
To solve this problem, we've used the following Expression for the Sort:
=Minstring({1}FieldToSortBy)
Are you describing the sort on state (ie. selected values or possible values appear first and not possible values appear last) that QV does? If so, you can disable this in the sort tab disabling the option to sort on "State".
Karl
Hi,
Un check the State option in the Sort tab of the Chart Properties.
Chart Properties-->Sort-->Uncheck the Sort by State option.
Celambarasan
Thanks for the responses, all. Unchecking Sort by State does not solve the problem. I don't want my list of values to re-sort at all when I select/de-select a value.
To solve this problem, we've used the following Expression for the Sort:
=Minstring({1}FieldToSortBy)
Thank God, I also didn't know how to fix this, since unchecking 'sort by state' also had no effect on my side.
I also had tried sort by expression = FieldToSortBy, but that also didn't help.
Your solution works perfectly!