topic Display multiple values in text box based on list box in QlikView

Display multiple values in text box based on list box

Wed, 04 Mar 2015 06:22:05 GMT

Dear All,

Good Morning,

I am in to a situation where i need to show multiple values in text box.

here is the scenario:

I have two list box named, Person Id and Certification , what i want to do is select one value in person id and values from certification box should be shown in a text box, ''Certification field contains multiple values'', I can only select in person id field.

Issue is text box displays the values from certification filed when there is only one value, for multiple values it shows blank data.

Thanks

Re: Display multiple values in text box based on list box

marcus_sommer — Wed, 04 Mar 2015 11:47:09 GMT

Try it with concat() as textbox-expression maybe with an additionally condition like:

if(getselectedcount([Person Id]) = 1, concat(Certification, ', '), 'to many values - please select one Id')

- Marcus

Re: Display multiple values in text box based on list box

anbu1984 — Wed, 04 Mar 2015 11:49:09 GMT

=Concat(DISTINCT Certification,',')

Re: Display multiple values in text box based on list box

Thu, 05 Mar 2015 05:25:02 GMT

Thanks All

Solved!!!