Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
JustinRamsey
Contributor III
Contributor III

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
Contributor III
Contributor III
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
Contributor III
Contributor III
Author

I think I figured it out. 

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

View solution in original post