Discussion Board for collaboration related to QlikView App Development.
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
try thsi
=isnull(GetFieldSelections(Country))
=GetFieldSelections(Country,', ', 200)
You need to specify the MAX value of records returned, the default is 6, check QV help file.
Andy
You can try this:
=GetFieldSelections(Country, ',', 100000)
or
=If(GetSelectedCount(Country) > 0, Concat(DISTINCT Country, ','))
=GetFieldSelections(Country,',',200)
Hi You can use ,
getcurrentselections (chr(13), '=', ';', 200 )
This will give you the selected fields of all the listboxes like this,
getfieldselections (Customer, ',' , 200 )
This will give only Customer List box,
HTH,
Hirish