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

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
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
MVP
MVP

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
MVP
MVP

Maybe something like

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

hope this helps

regards

Marco