topic listbox selection inText box, in QlikView

listbox selection inText box,

Wed, 25 Nov 2020 16:16:04 GMT

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

Test object

Japan

USA not like Japan USA

Re: listbox selection inText box,

trdandamudi — Tue, 10 Jan 2017 18:18:42 GMT

May be as below:

=Concat(Distinct Country& chr(13))

Re: listbox selection inText box,

Tue, 10 Jan 2017 18:22:29 GMT

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

thanks

Re: listbox selection inText box,

ger_alegria — Tue, 10 Jan 2017 18:24:34 GMT

Use the Function GetFieldSelections, i.e:

=GetFieldSelections(Year)

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

Re: listbox selection inText box,

ger_alegria — Tue, 10 Jan 2017 18:25:21 GMT

GetFieldSelections(Field_to_use)

Re: listbox selection inText box,

trdandamudi — Tue, 10 Jan 2017 18:26:27 GMT

How about the below expression:

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