topic Re: how to find weekago function? in QlikView https://community.qlik.com/t5/QlikView/how-to-find-weekago-function/m-p/1324230#M828338 <HTML><HEAD></HEAD><BODY><P>Please check this</P><P></P><P><A href="https://community.qlik.com/thread/67914">Create Indicator for 4, 8, and 13 weeks ago in Calendar</A></P></BODY></HTML> Tue, 04 Jul 2017 12:16:23 GMT prma7799 2017-07-04T12:16:23Z how to find weekago function? https://community.qlik.com/t5/QlikView/how-to-find-weekago-function/m-p/1324229#M828337 <HTML><HEAD></HEAD><BODY><P>how to find weekago function example 2012,2013</P><P>listbox should be 1-104th</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-find-weekago-function/m-p/1324229#M828337 krishna789 2020-11-25T16:16:04Z Re: how to find weekago function? https://community.qlik.com/t5/QlikView/how-to-find-weekago-function/m-p/1324230#M828338 <HTML><HEAD></HEAD><BODY><P>Please check this</P><P></P><P><A href="https://community.qlik.com/thread/67914">Create Indicator for 4, 8, and 13 weeks ago in Calendar</A></P></BODY></HTML> Tue, 04 Jul 2017 12:16:23 GMT https://community.qlik.com/t5/QlikView/how-to-find-weekago-function/m-p/1324230#M828338 prma7799 2017-07-04T12:16:23Z Re: how to find weekago function? https://community.qlik.com/t5/QlikView/how-to-find-weekago-function/m-p/1324231#M828339 <HTML><HEAD></HEAD><BODY><P>thanks PM</P><P>i got it with that reference link .</P><P>weekago:</P><P> ,53*(Year($(vMaxDate))-Year ([DATE])) + week($(vMaxDate) ) - week( [DATE]) as weekAgo.</P></BODY></HTML> Fri, 07 Jul 2017 05:53:09 GMT https://community.qlik.com/t5/QlikView/how-to-find-weekago-function/m-p/1324231#M828339 krishna789 2017-07-07T05:53:09Z Re: how to find weekago function? https://community.qlik.com/t5/QlikView/how-to-find-weekago-function/m-p/1324232#M828340 <HTML><HEAD></HEAD><BODY><P>Please close this thread with marking correct answer it will helpful to another one.</P></BODY></HTML> Fri, 07 Jul 2017 06:22:54 GMT https://community.qlik.com/t5/QlikView/how-to-find-weekago-function/m-p/1324232#M828340 prma7799 2017-07-07T06:22:54Z Re: how to find weekago function? https://community.qlik.com/t5/QlikView/how-to-find-weekago-function/m-p/1324233#M828341 <HTML><HEAD></HEAD><BODY><P><EM><span class="lia-unicode-emoji" title=":anguished_face:">😧</span></EM></P><P><EM>load</EM></P><P><EM>date(makedate(2015) + rowno() -1) as d</EM></P><P><EM>AutoGenerate 365*3;</EM></P><P></P><P><EM>let vMaxDate = Today();</EM></P><P></P><P><EM>left join (D)</EM></P><P><EM>load</EM></P><P><EM>d,</EM></P><P><EM><STRONG>DIV('$(vMaxDate)' - d, 7) as WeekAgo</STRONG></EM></P><P><EM>Resident D;</EM></P></BODY></HTML> Fri, 07 Jul 2017 07:28:11 GMT https://community.qlik.com/t5/QlikView/how-to-find-weekago-function/m-p/1324233#M828341 maxgro 2017-07-07T07:28:11Z