topic Latest 4 weeks in Trigger (Year-week combination) in QlikView

Latest 4 weeks in Trigger (Year-week combination)

mohan2391 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

* I have a field YEAR_WEEK, which consists of data in the form of YYYY-W## (EX: 2020-W32)

* I am using this field as a filter in a sheet

Requirement: On open this sheet, latest 4 weeks should be selected in the YEAR_WEEK field (sheet trigger)

Ex:2020-W29, 2020-W30, 2020-W31, 2020-W32

Please help me on this

Re: Latest 4 weeks in Trigger (Year-week combination)

asinha1991 — Wed, 23 Sep 2020 17:33:51 GMT

maybe something like this ='('&chr(39)&repalce(weekname(today()),'/','-W')&chr(39)&'|'&chr(39)&repalce(weekname(today()-7),'/','-W')&chr(39)&'|'&chr(39)&repalce(weekname(today()-14),'/','-W')&chr(39)&'|'&chr(39)&repalce(weekname(today()-28),'/','-W')&chr(39)&')'

Re: Latest 4 weeks in Trigger (Year-week combination)

Brett_Bleess — Tue, 20 Oct 2020 14:47:56 GMT

The other option would be to use the triggers along with actions to accomplish things, see the following Help links:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Sheet_Properties_Triggers.htm

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Button2.htm#anchor-4

I believe that should give you another avenue here.

Regards,
Brett