topic Date calculated for a Weekday in QlikView https://community.qlik.com/t5/QlikView/Date-calculated-for-a-Weekday/m-p/147188#M25639 <HTML><HEAD></HEAD><BODY><P>I made an expression to compare the sales of last day with the same week correspondent of day of the last year, and it worked fine.</P><P><STRONG>=Sum(<BR /> If(<BR /> (Num(YearName(DATA_VENDA),'YYYY'))=(num(YearName(today(),-1),'YYYY')) and<BR /> (Date(Month(DATA_VENDA),'MMMM'))=Date((Month(today())),'MMMM') and<BR /> (Date(Week(DATA_VENDA),'WWWW'))=Date((Week(today())),'WWWW') and<BR /> (WeekDay(DATA_VENDA)=WeekDay(today()-1))<BR /> ,VALOR_VENDA<BR /> )<BR /> )</STRONG></P><P>Now I´m trying to set an expression to the label of this expression, to show the date used in the result of the expression above, that is the same day week of yesterday, one year ago (i.e. 06/19/2008) - it was thursday, like yesterday.</P><P></P><P></P><P></P><P></P><BR /><BR /> <P></P><BR /><BR /> <P></P><P></P></BODY></HTML> Fri, 19 Jun 2009 13:10:14 GMT 2009-06-19T13:10:14Z Date calculated for a Weekday https://community.qlik.com/t5/QlikView/Date-calculated-for-a-Weekday/m-p/147188#M25639 <HTML><HEAD></HEAD><BODY><P>I made an expression to compare the sales of last day with the same week correspondent of day of the last year, and it worked fine.</P><P><STRONG>=Sum(<BR /> If(<BR /> (Num(YearName(DATA_VENDA),'YYYY'))=(num(YearName(today(),-1),'YYYY')) and<BR /> (Date(Month(DATA_VENDA),'MMMM'))=Date((Month(today())),'MMMM') and<BR /> (Date(Week(DATA_VENDA),'WWWW'))=Date((Week(today())),'WWWW') and<BR /> (WeekDay(DATA_VENDA)=WeekDay(today()-1))<BR /> ,VALOR_VENDA<BR /> )<BR /> )</STRONG></P><P>Now I´m trying to set an expression to the label of this expression, to show the date used in the result of the expression above, that is the same day week of yesterday, one year ago (i.e. 06/19/2008) - it was thursday, like yesterday.</P><P></P><P></P><P></P><P></P><BR /><BR /> <P></P><BR /><BR /> <P></P><P></P></BODY></HTML> Fri, 19 Jun 2009 13:10:14 GMT https://community.qlik.com/t5/QlikView/Date-calculated-for-a-Weekday/m-p/147188#M25639 2009-06-19T13:10:14Z Re: Date calculated for a Weekday https://community.qlik.com/t5/QlikView/Date-calculated-for-a-Weekday/m-p/147189#M25640 <HTML><HEAD></HEAD><BODY><P>Use makeweekdate function</P></BODY></HTML> Tue, 13 Nov 2012 09:53:04 GMT https://community.qlik.com/t5/QlikView/Date-calculated-for-a-Weekday/m-p/147189#M25640 2012-11-13T09:53:04Z