Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Set Text Field List Box Default OnOpen Trigger

Try to set in value field

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

MVP
MVP

Re: Set Text Field List Box Default OnOpen Trigger

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
Esteemed Contributor

Re: Set Text Field List Box Default OnOpen Trigger

Hi Lindsay

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

For multiple values, then it's like this:

HTH - ANDY

Not applicable

Re: Set Text Field List Box Default OnOpen Trigger

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.

MVP
MVP

Re: Set Text Field List Box Default OnOpen Trigger

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) & '")'