topic Re: Relative calendar field: WeeksAgo in QlikView https://community.qlik.com/t5/QlikView/Relative-calendar-field-WeeksAgo/m-p/500059#M1125563 <HTML><HEAD></HEAD><BODY><P>I found the answer somewhere</P><P></P><P>(WeekStart(Today()) - WeekStart(TempDate))/7 as WeeksAgo</P></BODY></HTML> Mon, 13 Jan 2014 10:27:02 GMT 2014-01-13T10:27:02Z Relative calendar field: WeeksAgo https://community.qlik.com/t5/QlikView/Relative-calendar-field-WeeksAgo/m-p/500058#M1125562 <HTML><HEAD></HEAD><BODY><P>Hi, i'm very new to Qliview and am trying to set up some relative calendar dates in my Master Calendar. I found these statements on one of the design blogs and they're very useful.</P><P><SPAN style="color: #0000ff;"><BR /></SPAN></P><P><SPAN style="color: #0000ff;">Today</SPAN>() - <SPAN style="color: #800000;">Date </SPAN><SPAN style="color: #0000ff;">as </SPAN><SPAN style="color: #800000;">DaysAgo</SPAN>,</P><P>12*(<SPAN style="color: #0000ff;">Year</SPAN>(<SPAN style="color: #0000ff;">Today</SPAN>())-<SPAN style="color: #0000ff;">Year</SPAN>(<SPAN style="color: #800000;">Date</SPAN>)) + <SPAN style="color: #0000ff;">Month</SPAN>(<SPAN style="color: #0000ff;">Today</SPAN>()) - <SPAN style="color: #0000ff;">Month</SPAN>(<SPAN style="color: #800000;">Date</SPAN>) <SPAN style="color: #0000ff;">as </SPAN><SPAN style="color: #800000;">MonthsAgo</SPAN>,</P><P></P><P>However, I really need one for WeeksAgo as well</P><P></P><P>My best guess was</P><P>52*(Week(Today())-Week(TempDate)) + Week(Today()) - Week(TempDate) as WeeksAgo</P><P></P><P>but this doesn't seem to work. What am I doing wrong?</P></BODY></HTML> Mon, 13 Jan 2014 09:54:50 GMT https://community.qlik.com/t5/QlikView/Relative-calendar-field-WeeksAgo/m-p/500058#M1125562 2014-01-13T09:54:50Z Re: Relative calendar field: WeeksAgo https://community.qlik.com/t5/QlikView/Relative-calendar-field-WeeksAgo/m-p/500059#M1125563 <HTML><HEAD></HEAD><BODY><P>I found the answer somewhere</P><P></P><P>(WeekStart(Today()) - WeekStart(TempDate))/7 as WeeksAgo</P></BODY></HTML> Mon, 13 Jan 2014 10:27:02 GMT https://community.qlik.com/t5/QlikView/Relative-calendar-field-WeeksAgo/m-p/500059#M1125563 2014-01-13T10:27:02Z