Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Text Field List Box Default OnOpen Trigger

hello i can't figure out the expression syntax to set a list box to a default value when the document is opened. I know how to do this for a numerical list box but not one that contains only text values. Can someone help?

5 Replies
maximiliano_vel
Partner - Creator III
Partner - Creator III

Try to set in value field

("Value1"|"Value2"|"Value3"|"... etc)

swuehl
MVP
MVP

Use a Select - Select in field action. Input your field name (without leading equal sign etc.) into the field entry box.

Use as search expression e.g.

("Lindsay Yurchick")

or for two values

("Lindsay Yurchick"|"Second name")

awhitfield
Partner - Champion
Partner - Champion

Hi Lindsay

If it's a single value, then like this:

For multiple values, then it's like this:

HTH - ANDY

Not applicable
Author

Hi All. The main issue is that there isn't a specific value that needs defaulted, the value is going to vary  based on the section access i have setup for customers. so i need syntax to be able to tell the app to default the value to a selection but it has to take the section access into account.

swuehl
MVP
MVP

How do you determine these values? Are you reduce data in a table based on section access that can be used?

If it's an unambigous field value per user, you can use an expression as search string like

=only(ReducedField)

or

='("' & only(ReducedField) & '")'