Setting multiple selections in a list box based on a variable

Tue, 13 Jul 2010 08:25:37 GMT

Okay, this seems so simple but I have yet to find any way to make it work.

We have a simple field I'll call GROUP, we load it in our script with distinct values from another field I'll call SALES_GROUP and this field is in two different tables to select different record types but the values are the same across both tables.

Our customer would like to select ORDER_SALES_GROUP on one table in Sheet A (call these Orders), clear it when leaving and then select the PROSPECTS_SALES_GROUP for Sheet B (call these Prospects) and clear it when leaving.

These two fields are not joined, nor does it make sense to do that.

We set up a list box to select GROUP, we save those selections in a variable (vlist) using GetFieldSelections(GROUP)

Example data looks like this in the selection: Current Value of vlist: " 0-In, ACCELVER"

When clicking to Sheet A, we would like to select the ORDER_SALES_GROUP list box using the variable vlist and have set up the triggers using the "select in field" and the value =vlist variable.

This all works fine with a single selected value (e.g., 0-In), but when we have multiple values, nothing gets selected in the ORDER_SALES_GROUP.

Bottom line question: How do you select multiple values in a list box using a variable?

Thanks for all help provided;-)

Setting multiple selections in a list box based on a variable

Tue, 13 Jul 2010 11:08:30 GMT

Hi Kim,

the syntax is: (Babykleidung|Bademode|Herrenmode)

Hope it helps!

Good luck!

Rainer

Setting multiple selections in a list box based on a variable

Wed, 26 Jan 2011 00:14:29 GMT

Thanks Rainer, been looking for that one.

topic Setting multiple selections in a list box based on a variable in QlikView

Setting multiple selections in a list box based on a variable

Setting multiple selections in a list box based on a variable

the syntax is: (Babykleidung|Bademode|Herrenmode)

Setting multiple selections in a list box based on a variable