Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

I do not like sheet defaults

Why does OnActivateSheet just not work?

I have 1 action currently and it is Select in Field

Field: =Year

SearchString: =Year(Today())

Can anyone tell me where I went wrong please

1 Solution

Accepted Solutions
Highlighted
Contributor II
Contributor II

Re: I do not like sheet defaults

In the Field remove '=' from '=Year'

View solution in original post

6 Replies
Highlighted
Contributor II
Contributor II

Re: I do not like sheet defaults

In the Field remove '=' from '=Year'

View solution in original post

Highlighted
Champion III
Champion III

Re: I do not like sheet defaults

What is the issue you are facing?

Highlighted
Specialist II
Specialist II

Re: I do not like sheet defaults

in the search String :

= year(Today())

don't forget =

that works for me

regards

Highlighted
Contributor III
Contributor III

Re: I do not like sheet defaults

It will not use the current year, it only uses the date that I had previously selected when it was open last.

Highlighted
Contributor III
Contributor III

Re: I do not like sheet defaults

Still nothing.

Highlighted
Contributor III
Contributor III

Re: I do not like sheet defaults

It works I was just saving every time I clicked a different date so that it would open up to that one,