Sort by Selection in Concat Function

[#1]

Hi,

I have ListBox, I need that when multiples values are selected, the concat function takes the values in the order in which they were selected.

For example:

The ListBox shows the following values,

BUENOS AIRES

CÓRDOBA

SANTA FE

FORMOSA

CATAMARCA

And i selected

CATAMARCA

BUENOS

SANTA FE

The concat function sorts the values according to the selection the user has made and not alphabetically or load order.

Someone could do this?

Thanks!!

[settu_periasamy]

Can you post the sample qvw and how do you want to see expected result in which object?

[sunny_talwar]

AFAIK this is not possible

[settu_periasamy]

stalwar1‌ if you don't mind, can you tell what the op needs? , sorry i didn't get the op needs.

[sunny_talwar]

Sure, as per what I understand he is looking for a way to sort in a concat function based on the selection order. So this is OPs list of available selection

BUENOS AIRES

CÓRDOBA

SANTA FE

FORMOSA

CATAMARCA

If users select

1) CATAMARCA

2) CÓRDOBA

3) SANTA FE

Concat function should give this -> CATAMARCA, CÓRDOBA, SANTA FE

If the user select

1) SANTA FE

2) BUENOS AIRES

Concat function should give this -> SANTA FE, BUENOS AIRES

So basically based on what's get selected first should be first in the list. AFAIK this isn't possible, but may be there is a way to do this.

mauricio_mattocup‌ - Please feel free to disagree with what I have explained to Settu.

Best,

Sunny

[settu_periasamy]

Thanks stalwar1‌

[sunny_talwar]

No problem Settu!! Is this possible?

[settu_periasamy]

I don't think so.

May be (not sure) macro would do that. checking on the Trigger event (Onselect / OnChange) and macro.

[#9]

Hi Sunny, this is exactly what i need.

The objective is to parse the text string to go enabling dimensions in a pivot table, but the concat function string commands in alphabetical order and I need to respect the order of user selection