topic Re: Use trigger to select first possible value? in QlikView

Use trigger to select first possible value?

bullish35 — Sat, 08 Mar 2014 00:01:50 GMT

I would like to set the value of a particular field when I navigate to a tab. For example, if I navigate to tab A and the field Market has no values selected, I would like to select whichever possible value is first in the list of values. Can I do that with a Select in Field or Select Possible trigger? Using what expression?

Thank you!

Ellen

Re: Use trigger to select first possible value?

Sat, 08 Mar 2014 00:34:04 GMT

Sure you can

In Sheet Properties click Triggers and Add Action (Select in Field)

put into Field box your Field name such as:

then write into Search Expression box:

=MaxString({1} F1)

=MinString({1} F1)

if the field ordered it will select minumum or maximum value available in your field

see attached example.

Re: Use trigger to select first possible value?

Alejandro_Hernández — Sat, 08 Mar 2014 00:56:57 GMT

try with =FirstSortedValue(field,field)