Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

List Box Re-sort on Select/De-Select

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?    

1 Solution

Accepted Solutions
Highlighted
Not applicable

List Box Re-sort on Select/De-Select

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)

4 Replies
Luminary
Luminary

List Box Re-sort on Select/De-Select

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

Hi,

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

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

Celambarasan

Highlighted
Not applicable

List Box Re-sort on Select/De-Select

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)

luciancostin
New Contributor III

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

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!