Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
JustinRamsey
Creator
Creator

Where Statement for Current Week Only

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.  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. 

1 Solution

Accepted Solutions
JustinRamsey
Creator
Creator
Author

I think I figured it out. 

where(Week(AFRU.BUDAT)=week(today())) and (Year(AFRU.BUDAT)=year(today()))

View solution in original post

1 Reply
JustinRamsey
Creator
Creator
Author

I think I figured it out. 

where(Week(AFRU.BUDAT)=week(today())) and (Year(AFRU.BUDAT)=year(today()))