Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I think I figured it out.
where(Week(AFRU.BUDAT)=week(today())) and (Year(AFRU.BUDAT)=year(today()))
I think I figured it out.
where(Week(AFRU.BUDAT)=week(today())) and (Year(AFRU.BUDAT)=year(today()))