Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to display selected two countries in same Listbox as concatenated string

Hi

I am not getting how to display selected two countries in same Listbox as concatenated string.

i.e. for example..

Country listbox consisting following contry names..

India

UnitedStates

United Kingdome

Canada

France

I have been selected two countries (e.g : India , UnitedStates) in above Listbox then It will display like "IndiaUnitedStaes".

how can I get that result.

Please help me .

Thanks & regards :

seshukumar bandaru.

1 Solution

Accepted Solutions
rustyfishbones
Master II
Master II

this is not ideal but it works

=REPLACE(REPLACE(REPLACE(GetCurrentSelections(Country),',',''),' ',''),'Country:','')

View solution in original post

5 Replies
rustyfishbones
Master II
Master II

this is not ideal but it works

=REPLACE(REPLACE(REPLACE(GetCurrentSelections(Country),',',''),' ',''),'Country:','')

Not applicable
Author

Thank you Alan Farrell I have solved my issue..

rustyfishbones
Master II
Master II

Great, but you should use Gysbert's solution

It's a much better solution

I am still learning, so I may do things the hard way, but as long as the result is correct

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

This seems to work somewhat and isn't bothered by selections in other fields:

1. Create a variable vC as =concat(DISTINCT Country).

2. Use as expression for the listbox =if(GetSelectedCount(Country),vC,Country).

Unselecting isn't very nice though, requiring two clicks.


talk is cheap, supply exceeds demand
Not applicable
Author

great Gysbert Wassenaar & thanQ.. its working ..