Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
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. 

Labels (1)
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()))