topic List Box Re-sort on Select/De-Select in QlikView

List Box Re-sort on Select/De-Select

Mon, 05 Mar 2012 20:57:53 GMT

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?

List Box Re-sort on Select/De-Select

pover — Tue, 06 Mar 2012 00:38:36 GMT

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

List Box Re-sort on Select/De-Select

CELAMBARASAN — Tue, 06 Mar 2012 04:28:42 GMT

Hi,

Un check the State option in the Sort tab of the Chart Properties.

Chart Properties-->Sort-->Uncheck the Sort by State option.

Celambarasan

List Box Re-sort on Select/De-Select

Tue, 06 Mar 2012 14:08:39 GMT

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)

Re: List Box Re-sort on Select/De-Select

Anonymous — Wed, 14 Jun 2017 11:34:56 GMT

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!