topic Re: Previous YearWeek of the current date in script in QlikView https://community.qlik.com/t5/QlikView/Previous-YearWeek-of-the-current-date-in-script/m-p/1012374#M343390 <HTML><HEAD></HEAD><BODY><P>If I understand your issue correctly, the <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">weekstart(Timekey, -1) should do the trick.</SPAN></P><P></P><P>VK</P></BODY></HTML> Tue, 17 Nov 2015 22:06:18 GMT vlad_komarov 2015-11-17T22:06:18Z Previous YearWeek of the current date in script https://community.qlik.com/t5/QlikView/Previous-YearWeek-of-the-current-date-in-script/m-p/1012373#M343389 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am trying to filter data to fetch only records from the previous year week of the current date. Till now I managed to do it hard coded at following:</P><P></P><P>WeekYear(Timekey) &amp; right('00' &amp; week(weekstart(Timekey)),2) = '201544'</P><P></P><P>Is it possible to swap '201544' to a function that return the previous yearweek of the current date without hardcoding the value. I cannot find anything regarding how this can be done.</P><P></P><P>Regards,</P><P>Matt</P></BODY></HTML> Tue, 03 Nov 2015 09:27:32 GMT https://community.qlik.com/t5/QlikView/Previous-YearWeek-of-the-current-date-in-script/m-p/1012373#M343389 2015-11-03T09:27:32Z Re: Previous YearWeek of the current date in script https://community.qlik.com/t5/QlikView/Previous-YearWeek-of-the-current-date-in-script/m-p/1012374#M343390 <HTML><HEAD></HEAD><BODY><P>If I understand your issue correctly, the <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">weekstart(Timekey, -1) should do the trick.</SPAN></P><P></P><P>VK</P></BODY></HTML> Tue, 17 Nov 2015 22:06:18 GMT https://community.qlik.com/t5/QlikView/Previous-YearWeek-of-the-current-date-in-script/m-p/1012374#M343390 vlad_komarov 2015-11-17T22:06:18Z