https://community.qlik.com/t5/QlikView/Where-Statement-for-Current-Week-Only/m-p/1736453#M452652 <P>I think I figured it out.&nbsp;</P><P>where(Week(AFRU.BUDAT)=week(today())) and (Year(AFRU.BUDAT)=year(today()))</P> Mon, 17 Aug 2020 16:49:45 GMT JustinRamsey 2020-08-17T16:49:45Z https://community.qlik.com/t5/QlikView/Where-Statement-for-Current-Week-Only/m-p/1736431#M452651 <P>I am needing help with a load statement. I am looking to only load values from a table that occur within the current week (Sun-Sat) for date field AFRU.BUDAT.&nbsp; Something logically stating Where AFRU.BUDAT is in the same week as today(). Using Qlik and Nprint and the requested report looks like the image. Just want it to only show the current week. No need for the extra data.&nbsp;</P> Mon, 17 Aug 2020 15:11:28 GMT https://community.qlik.com/t5/QlikView/Where-Statement-for-Current-Week-Only/m-p/1736431#M452651 JustinRamsey 2020-08-17T15:11:28Z https://community.qlik.com/t5/QlikView/Where-Statement-for-Current-Week-Only/m-p/1736453#M452652 <P>I think I figured it out.&nbsp;</P><P>where(Week(AFRU.BUDAT)=week(today())) and (Year(AFRU.BUDAT)=year(today()))</P> Mon, 17 Aug 2020 16:49:45 GMT https://community.qlik.com/t5/QlikView/Where-Statement-for-Current-Week-Only/m-p/1736453#M452652 JustinRamsey 2020-08-17T16:49:45Z