Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to set a trigger to select current year when opening?

Hi,

Could someone please advise me on how I set a trigger to select current year in the table 'YearAsOf' when opening a tab?

I know how to get to the trigger option but unsure what to select / add from here.

Many thanks.

John

1 Solution

Accepted Solutions
Not applicable
Author

Dear go to sheet properties >>Triggers>>Edit Actions>> and follow attachmentYear Alert.jpg

View solution in original post

2 Replies
fdelacal
Specialist
Specialist

triggers--- edit action on open.

Action ...Select in field

Field= (DATE)

Searching Strign

= Year(today())

Regards

Not applicable
Author

Dear go to sheet properties >>Triggers>>Edit Actions>> and follow attachmentYear Alert.jpg