How can we derive last 5 weeks from sysdate . The week should be from Saturday to Friday . Today is monday means we should have last Saturday(22 nd Sep - 29 sEP), similarly i need to derive last 5 weeks.
This is static right. I want this to be dynamic, so that it always brings last week frpm Sunday - Saturday. If it runs today it should bring from 22nd - 28th until this week is finished. The output will be same until we have the complete week.
It's not static. It can be implemented dynamically as well. Please share a sample app with explained expected output; you might be helped in an efficient way. You might want to have a look at this qlikview design post by Henric Cronström for better understanding and learning.