Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
apoorvasd
Creator II
Creator II

Trigger to select current week by default when a tab is opened

Hello Everyone,

How can I set a sheet trigger which applies the condition that, when a that tab is opened by default latest week to which the current date belongs to should be selected?

For example, as today's date is 3rd October 2017, when I open tab, "Sheet1"  in the app attached, by default in my week field (WeekShort), 06/10/2017 should be chosen as 3rd Oct belongs to this week as per my data in the attached excel sheet. How can I achieve this?

Thank you.

1 Solution

Accepted Solutions
sunny_talwar

Try this for Select in Field search string

=Min({<WeekShort = {"$(='>=' & Date(Today()))"}>}WeekShort)

View solution in original post

2 Replies
sunny_talwar

Try this for Select in Field search string

=Min({<WeekShort = {"$(='>=' & Date(Today()))"}>}WeekShort)

apoorvasd
Creator II
Creator II
Author

Yes, that worked!

Thanks a lot