Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Nino
Contributor III
Contributor III

inputbox constrains from a table field

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.

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

 

View solution in original post

7 Replies
dplr-rn
Partner - Master III
Partner - Master III

Did you try concat(your_field, ',') as a predefined list?
Please expand the scenario
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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. 

2018-12-20_9-40-16.jpg

 

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

Nino
Contributor III
Contributor III
Author

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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

 

-Rob

Nino
Contributor III
Contributor III
Author

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Contributor III
Contributor III
Author

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

N.