Sheet trigger action OnActivateSheet Select In Field

[matthewp]

I am trying to add an action in a sheet trigger top make a default selection however i cant get it to work.

Field

=YEAR(CREATTION_DATE)

Search String

(2014|2015)

Where am i going wrong?

[maxgro]

FIELD

YEAR

not

=YEAR

[rubenmarin]

Can you upload a sample? worked for me in one of my documents.

From your answer to Sergey, you created a field 'Year' but you are using field name 'YEAR', field names are case sensitive, so 'Year' and 'YEAR' are different field names.

[SergeyMak]

QlikView is case sensitive with field names. SO, if you created field Year, you have to use Year

[matthewp]

Case sensitivity was causing my issue!! thank you!