topic Re: Previous week in QlikView https://community.qlik.com/t5/QlikView/Previous-week/m-p/126286#M752778 <HTML><HEAD></HEAD><BODY><P>Hi, Haseeb.&nbsp; I think you've missed a $ sign. Try this</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> =Sum({$&lt;[CalendarLink]={'<STRONG>$</STRONG>(=vPreviousWeek)'}&gt;}OTHours)</SPAN></P></BODY></HTML> Tue, 23 Oct 2018 07:22:08 GMT andrey_krylov 2018-10-23T07:22:08Z Previous week https://community.qlik.com/t5/QlikView/Previous-week/m-p/126285#M752777 <HTML><HEAD></HEAD><BODY><P>I am using this set analysis =Sum({$&lt;[CalendarLink]={'(=vPreviousWeek)'}&gt;}OTHours) to get my previous week data, this expression is not giving me the right result.</P><P></P><P>My variable is as follows:</P><P>=date(CalendarLink-7)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Previous-week/m-p/126285#M752777 has75042 2020-11-25T16:16:04Z Re: Previous week https://community.qlik.com/t5/QlikView/Previous-week/m-p/126286#M752778 <HTML><HEAD></HEAD><BODY><P>Hi, Haseeb.&nbsp; I think you've missed a $ sign. Try this</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> =Sum({$&lt;[CalendarLink]={'<STRONG>$</STRONG>(=vPreviousWeek)'}&gt;}OTHours)</SPAN></P></BODY></HTML> Tue, 23 Oct 2018 07:22:08 GMT https://community.qlik.com/t5/QlikView/Previous-week/m-p/126286#M752778 andrey_krylov 2018-10-23T07:22:08Z