topic Re: Sort by Selection in Concat Function in QlikView

Sort by Selection in Concat Function

Wed, 12 Oct 2016 15:55:57 GMT

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!!

Re: Sort by Selection in Concat Function

settu_periasamy — Wed, 12 Oct 2016 18:58:55 GMT

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

Re: Sort by Selection in Concat Function

sunny_talwar — Wed, 12 Oct 2016 19:00:02 GMT

AFAIK this is not possible

Re: Sort by Selection in Concat Function

settu_periasamy — Wed, 12 Oct 2016 19:16:04 GMT

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

Re: Sort by Selection in Concat Function

sunny_talwar — Wed, 12 Oct 2016 19:20:26 GMT

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

Re: Sort by Selection in Concat Function

settu_periasamy — Wed, 12 Oct 2016 19:22:00 GMT

Thanks stalwar1‌

Re: Sort by Selection in Concat Function

sunny_talwar — Wed, 12 Oct 2016 19:22:38 GMT

No problem Settu!! Is this possible?

Re: Sort by Selection in Concat Function

settu_periasamy — Wed, 12 Oct 2016 19:29:33 GMT

I don't think so.

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

Re: Sort by Selection in Concat Function

Wed, 12 Oct 2016 19:31:00 GMT

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