topic Re: how to display selected two countries in same Listbox as concatenated string in QlikView

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

Thu, 13 Jun 2013 10:17:41 GMT

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.

rustyfishbones — Thu, 13 Jun 2013 10:26:44 GMT

this is not ideal but it works

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

Thu, 13 Jun 2013 10:31:46 GMT

Thank you Alan Farrell I have solved my issue..

rustyfishbones — Thu, 13 Jun 2013 10:35:48 GMT

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 — Thu, 13 Jun 2013 10:46:10 GMT

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.

Thu, 13 Jun 2013 10:52:54 GMT

great Gysbert Wassenaar & thanQ.. its working ..