topic Re: Set Text Field List Box Default OnOpen Trigger in QlikView

Set Text Field List Box Default OnOpen Trigger

Thu, 13 Aug 2015 15:03:29 GMT

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?

Re: Set Text Field List Box Default OnOpen Trigger

maximiliano_vel — Thu, 13 Aug 2015 15:05:41 GMT

Try to set in value field

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

Re: Set Text Field List Box Default OnOpen Trigger

swuehl — Thu, 13 Aug 2015 15:07:31 GMT

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

Re: Set Text Field List Box Default OnOpen Trigger

awhitfield — Thu, 13 Aug 2015 15:30:18 GMT

Hi Lindsay

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

For multiple values, then it's like this:

HTH - ANDY

Re: Set Text Field List Box Default OnOpen Trigger

Thu, 13 Aug 2015 15:33:15 GMT

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.

Re: Set Text Field List Box Default OnOpen Trigger

swuehl — Thu, 13 Aug 2015 15:42:17 GMT

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)

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