Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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