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

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

apoorvasd — Tue, 03 Oct 2017 14:25:28 GMT

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.

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

sunny_talwar — Tue, 03 Oct 2017 14:30:34 GMT

Try this for Select in Field search string

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

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

apoorvasd — Tue, 03 Oct 2017 14:36:19 GMT

Yes, that worked!

Thanks a lot