Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mambi
Creator III
Creator III

Listbox selection and concat order

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 ?

8 Replies
Gysbert_Wassenaar

That's not possible afaik.


talk is cheap, supply exceeds demand
kumarkp412
Creator II
Creator II

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

mambi
Creator III
Creator III
Author

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

Anonymous
Not applicable

Hi

Try like this ? in text box ...

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

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

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

mambi
Creator III
Creator III
Author

doesn't work too

Anonymous
Not applicable

Hi

will  you try this following as expresssion ?

=if(

  GetFieldSelections( customersID)>0,

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

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

'))'

)

Edited :

jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
mambi
Creator III
Creator III
Author

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