topic Re: Listbox selection and concat order in QlikView

Listbox selection and concat order

mambi — Wed, 10 Aug 2016 10:53:28 GMT

Hello every,

i have a liste box for customersIDs with values :

ID1,

ID2,

ID3

and i have a textbox

Now i want to display in the textbox my selections from customersIDs but with the selection order :

i mean if i select ID2 first then ID1 then ID3 the result in the textbox i should be ID2,ID1,ID3

any idea ?

Re: Listbox selection and concat order

Gysbert_Wassenaar — Wed, 10 Aug 2016 11:08:50 GMT

That's not possible afaik.

Re: Listbox selection and concat order

kumarkp412 — Wed, 10 Aug 2016 11:45:15 GMT

Hi Mambi,

Please, check the attachment.

But in this, i created the button to show the values and clear the values.

hope this may help you.

Thanks

Kumar

Re: Listbox selection and concat order

mambi — Wed, 10 Aug 2016 12:15:59 GMT

not really what i want because each time i must click the button

Re: Listbox selection and concat order

Anonymous — Wed, 10 Aug 2016 12:23:38 GMT

Try like this ? in text box ...

=if(Aggr(Sum(1), customersID)>0,

'Selected: $(=Concat(DISTINCT customersID, ', '))',

'Others: $(=Concat({<Country=E({$})>} DISTINCT customersID, ', '))')

Re: Listbox selection and concat order

mambi — Wed, 10 Aug 2016 12:55:13 GMT

doesn't work too

Re: Listbox selection and concat order

Anonymous — Wed, 10 Aug 2016 13:05:48 GMT

will you try this following as expresssion ?

=if(

GetFieldSelections( customersID)>0,

'Selected: $(=Concat(DISTINCT customersID, ', '))',

'Others: $(=Concat({<customersID=E({$})>} DISTINCT customersID, ',

'))'

)

Edited :

Re: Listbox selection and concat order

jonathandienst — Wed, 10 Aug 2016 13:29:40 GMT

Agreed - Qlikview does not store or care about the order in which selections are made - it only maintains state. It does store the state history (like clicking the go back and go forward buttons) which you can retrieve using special set analysis modifiers, but it would not be easy (and may not be possible at all) to get this into a sort order for a single field.

Re: Listbox selection and concat order

mambi — Wed, 10 Aug 2016 13:37:30 GMT

Sorry, but i get the same result, i can't have the wondered order based on my selections