Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
musketeers
Creator
Creator

getfieldselections not returning all selected value

Hi,

In my list box I have around 200 values. I want to display the values selected in that list box in a Text Box. I am using getfieldselections to get the selected values.

Now for some very few selection Like if 5 values are selected in list box, GetFieldSelections is displaying the indivisual values selected in text box.

Now I have selected 8 values, the function is displaying 8 of 200.

Is there any way we can get all the values selected in the list box.

I am using this function like this:

=GetFieldSelections(Country)

Please help me here.

Thanks

Rajneesh

6 Replies
Chanty4u
MVP
MVP

try thsi

=isnull(GetFieldSelections(Country))

swuehl
MVP
MVP

=GetFieldSelections(Country,', ', 200)

awhitfield
Partner - Champion
Partner - Champion

You need to specify the MAX value of records returned, the default is 6, check QV help file.

Andy

sunny_talwar

You can try this:

=GetFieldSelections(Country, ',', 100000)

or

=If(GetSelectedCount(Country) > 0, Concat(DISTINCT Country, ','))

Anonymous
Not applicable

=GetFieldSelections(Country,',',200)

HirisH_V7
Master
Master

Hi You can use ,

getcurrentselections (chr(13), '=', ';', 200 )

This will give you the selected fields of all the listboxes like this,

List box selection Values.PNGgetfieldselections (Customer, ',' , 200 )

This will give only Customer List box,

List box selection Values2.PNG

HTH,

Hirish

HirisH
“Aspire to Inspire before we Expire!”