topic List Boxes with Alternate States in QlikView

List Boxes with Alternate States

Mon, 05 Aug 2013 17:57:18 GMT

I have two list boxes. Each List box is in its own state. If I select 5 "vendors" in one of the list boxes, how do I use Select in Field (in a button) to also chose those "vendors" in the second list box. I have been using the expression below to make the selections in the Select in Field search string but it will only work for one "vendor" at a time. I need to select all vendors at once. Does anyone understand what I am doing wrong?

=Concat(DISTINCT {[Category Analysis]} Vendor, '|')

Re: List Boxes with Alternate States

swuehl — Mon, 05 Aug 2013 18:38:18 GMT

Have you tried like this:

='(' & Concat(DISTINCT {[Category Analysis]} Vendor, '|') & ')'

Re: List Boxes with Alternate States

Mon, 05 Aug 2013 18:56:05 GMT

This is partially working but it is only selecting names with no spaces. Is there is a space in the name it does not work. Any idea on how to work around this?

JEREMY TERLESCKI

SOURCING OPERATIONS ASSOCIATE

T: 484.690.5418

E: jterlescki@procurian.com<mailto:jterlescki@procurian.com> | W: procurian.com<http://www.procurian.com>

CONNECT WITH PROCURIAN ON:

<http://www.linkedin.com/company/procurian?trk=hb_tab_compy_id_164269> <https://www.facebook.com/Procurian> <https://twitter.com/Procurian> <http://www.youtube.com/user/Procurian>

Re: List Boxes with Alternate States

swuehl — Mon, 05 Aug 2013 20:18:30 GMT

I believe values with spaces need to be surrounded by double quotes, so try this:

='("' & Concat(DISTINCT {[Category Analysis]} Vendor, '"|"') & '")'