topic Re: inputbox constrains from a table field in QlikView

inputbox constrains from a table field

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

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.

Re: inputbox constrains from a table field

dplr-rn — Thu, 20 Dec 2018 17:41:25 GMT

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

Re: inputbox constrains from a table field

rwunderlich — Thu, 20 Dec 2018 17:50:08 GMT

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

Re: inputbox constrains from a table field

Nino — Thu, 20 Dec 2018 18:13:36 GMT

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.

Re: inputbox constrains from a table field

rwunderlich — Thu, 20 Dec 2018 18:17:07 GMT

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

-Rob

Re: inputbox constrains from a table field

Nino — Thu, 20 Dec 2018 19:15:37 GMT

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

Re: inputbox constrains from a table field

rwunderlich — Thu, 20 Dec 2018 19:49:24 GMT

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

Re: inputbox constrains from a table field

Nino — Fri, 21 Dec 2018 17:10:52 GMT

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

N.