Adding Select in Field to trigger in Sheet - nothing happens..

[hansdevr]

Hi everyone,

I want to add two triggered actions upon activating a Worksheet. The first is to Clear All and the second is to automatically select the current Registration Year (Jaar registr.). I tried all sorts of ways to achieve this (see picture above) but it just won't work...

What am I doing wrong?!?

[Chanty4u]

chk below

[hansdevr]

Unfortunately, that syntax  =$(=max([Jaar registr.])) also didn't do it...

[israrkhan]

Hi,

you just need to remove the = sign from field box..

must be like this

[Jaar registr.]

=max([Jaar registr.])

[hansdevr]

Hi IsrarKhan,

See picture below.. Still no show...

[Chanty4u]

can u share sample qvw?

bcz it shud wrk..  or else u can try in document properties?

[Chanty4u]

better can u remove that clear all triget and try once.   by that u can knw what is the issue?

[hansdevr]

This qvw is quite large, so unfortunately I can't share it - also there are security restrictions...

[jerrysvensson]

Try 2015 instead of Max([Jaar registr.]), just to see if it works. If 2015 is in your data set of course.

[hansdevr]

Neither 2015 or '2015' worked, and yes - it is in the data set...

[hansdevr]

That also didn't do the trick...