inputbox constrains from a table field

[Nino]

Hi,

I need to get the constraints of a listbox from the possible value of a field: how cai I achieve that?

Thank you so much.

N.

[dplr-rn]

Did you try concat(your_field, ',') as a predefined list?
Please expand the scenario

[rwunderlich]

If you use the predefined values option a comma separated list will provide the allowed values.  You can use a "concat(Distinct fieldname, '.')" expression to build the list.  The list separator (the comma) must match the windows list separator in your windows control panel Region settings.  On some European machines, it's a semicolon instead of a comma. 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[Nino]

Thank you for the replies: I'd like to have something like the Multibox (allowing partial input of the searched fields, showing the complete list of all the possible values etc, but setting my variable.

Pls, see my attachment of I'm not clear enought.

Thank you so much.

[rwunderlich]

Use a Multibox of a Listbox along with a Select Field trigger that sets the variable. 

-Rob

[Nino]

Would you be so kind to give me a little example of your suggestion, pls?

(Consider that I don't want to set the field, because it would involve all the table of all the sheets of my qw file, but only the variable, si that all the other selection would not be involved).

Thank you so much

[rwunderlich · Accepted solution]

You can place the field in an alternate state to prevent changes to your other sheets/objects.  Attached is an example from your qvw. 

1. Code listbox if placed in Alternate State "VariableSet".

2. Document Properties, Triggers, Field Event Trigger (for Code), On Select is set to Set Variable = vChoice with value
=MinString({VariableSet}Code)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[Nino]

Such a great suggestion! Thank you so much for your help!

N.