Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
did you try this?
can you explain more
what is your expression ? where you are suing this?
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)),',').
Use sort expression like:
=match(Only({1}Field), 'Value1', 'Value2') like
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.
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.