topic Re: getfieldselections not returning all selected value in QlikView

getfieldselections not returning all selected value

musketeers — Thu, 31 Mar 2016 11:53:00 GMT

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

Re: getfieldselections not returning all selected value

Chanty4u — Thu, 31 Mar 2016 11:55:07 GMT

try thsi

=isnull(GetFieldSelections(Country))

Re: getfieldselections not returning all selected value

swuehl — Thu, 31 Mar 2016 11:55:10 GMT

=GetFieldSelections(Country,', ', 200)

Re: getfieldselections not returning all selected value

awhitfield — Thu, 31 Mar 2016 12:06:59 GMT

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

Andy

Re: getfieldselections not returning all selected value

sunny_talwar — Thu, 31 Mar 2016 12:09:00 GMT

You can try this:

=GetFieldSelections(Country, ',', 100000)

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

Re: getfieldselections not returning all selected value

Anonymous — Sun, 03 Apr 2016 05:57:58 GMT

=GetFieldSelections(Country,',',200)

Re: getfieldselections not returning all selected value

HirisH_V7 — Sun, 03 Apr 2016 08:03:08 GMT

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