topic Re: dont sort values when user select values in QlikView

dont sort values when user select values

ing_jesus_lopez — Mon, 26 Jan 2026 18:19:17 GMT

hello,

I need save values of selections, when the user select values in mutlibox object i need skip the sort because qlikview sort automatically the values.

Example: When the user select 4-2017, 3-2017, 2-2017, qlikview sort values, 2-2107, 3-2017, 4-217, i need skip this order and save the values in variable.

vVariable = 4-2017, 3-2017, 2-2017

Regards.

Re: dont sort values when user select values

vishsaggi — Tue, 12 Jun 2018 15:57:04 GMT

did you try this?

Re: dont sort values when user select values

Chanty4u — Tue, 12 Jun 2018 16:01:39 GMT

can you explain more

what is your expression ? where you are suing this?

Re: dont sort values when user select values

ing_jesus_lopez — Tue, 12 Jun 2018 16:02:58 GMT

Hello vishsaggi

Yes i try but the result be the same, qlikview sort the values

Regards.

Re: dont sort values when user select values

ing_jesus_lopez — Tue, 12 Jun 2018 16:09:20 GMT

hello Csureshqv

I need to save values as the user makes the selection, that is, if the user first selects the value 4-2017 and then 3-2017, in the variable these values are saved, but qlivkiew orders the values. To save the values I used GetFieldSelections(FIELD) and Concat(Distinct((FIELD)),',').

Re: dont sort values when user select values

Chanty4u — Tue, 12 Jun 2018 16:14:36 GMT

Use sort expression like:

=match(Only({1}Field), 'Value1', 'Value2') like

Re: dont sort values when user select values

ing_jesus_lopez — Tue, 12 Jun 2018 16:24:48 GMT

Hello sureshqv

When i use match i should be introduce the values for evaluate, i have 20 values, i thinking save the values every selection of the user.

Re: dont sort values when user select values

vishsaggi — Tue, 12 Jun 2018 21:38:02 GMT

You can try using Concat(GetFieldSelections(Field), ',', GetFieldSelections(Field)) in your text object. But i believe this Concat with sort weight will do Asc sorting, not sure if we can override it.

stalwar1‌ marcowedel‌ any ideas on this.

basically when the users selects any Multibox in any order the selection should be dynamically sorted and display in Textobject.