Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

listbox selection inText box,

i have a list box name country with multiple country  ,,, how can i crate a text object that when i select multiple countries all the country will show in text object ,,desplay in text object should be top to down .

for ex when i select japan and USA

listbox

japan

USA

UK 

Test object

Japan

USA                      not like Japan USA

1 Solution

Accepted Solutions
ger_alegria
Partner
Partner

Use the Function GetFieldSelections, i.e:

=GetFieldSelections(Year)

You will see in your text object the years that you selected.

View solution in original post

5 Replies
trdandamudi
Master II
Master II

May be as below:

=Concat(Distinct Country& chr(13))

Not applicable
Author

HI thanks it works but when nothing is selected all country display in text object,, is there way to to some set analysis

thanks

ger_alegria
Partner
Partner

Use the Function GetFieldSelections, i.e:

=GetFieldSelections(Year)

You will see in your text object the years that you selected.

ger_alegria
Partner
Partner

GetFieldSelections(Field_to_use)

trdandamudi
Master II
Master II

How about the below expression:

=If(GetSelectedCount(Country)>0, Concat(Distinct Country & chr(13)))