Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What is a closed week? Do you mean last 8 completed weeks? What is the last day of week for you? Saturday or Sunday?
Maybe something like
Date>=WeekStart(Today()+1,-8)
hope this helps
regards
Marco