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: 
diordache10
Contributor
Contributor

Closed weeks

Hello,

Can you please tell me how can i get in QlikView the last 8 closed weeks?(maybe from variables) For example today is Wednesday 28-03-201 and this is not a closed week.  I have to show only the closed ones.

Thanks,

D

Labels (1)
2 Replies
sunny_talwar

What is a closed week? Do you mean last 8 completed weeks? What is the last day of week for you? Saturday or Sunday?

MarcoWedel

Maybe something like

Date>=WeekStart(Today()+1,-8)

hope this helps

regards

Marco