topic To Display selected List Box values in Table Box Caption in QlikView

To Display selected List Box values in Table Box Caption

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am able to bring the single selected value in the list box to the "Table Box Caption ". But I am not able to bring the values if multiple list box values are selected. Attached screen shot and supporting files for your reference. Thanks in advanced

Re: To Display selected List Box values in Table Box Caption

ThornOfCrowns — Fri, 17 Jun 2016 09:14:13 GMT

Look at GetCurrentSelections(Field)

Re: To Display selected List Box values in Table Box Caption

Kushal_Chawda — Fri, 17 Jun 2016 09:14:58 GMT

try below expression

=getfieldselections(Department,',')

Re: To Display selected List Box values in Table Box Caption

Anonymous — Fri, 17 Jun 2016 09:27:31 GMT

Thank you James and Kushal. Both the answers are correct. I could see minor difference in the presentation part.

1. Getcurrentselection(Fieldname) --> Fieldname: list box selected values (By default "," separator)

2. Getfieldselection(Fieldname) --> list box selected values (Separator can be defined as per users requirement)

=GetCurrentSelections(Fieldname,'|',',') - gives some additional facilities

Thank you so much to both of you