topic Re: Week Start Day in QlikView

Week Start Day

Fri, 13 Jul 2012 14:02:47 GMT

Hi All,

This might be a basic QV question, but figured I'd throw it out there. Our QV is set so that Weeks start on a Monday. Traditionally our reporting for other systems, our week starts on Sunday. Does anyone know how I can change the QV default so that "vThisWeek" always starts on Sunday instead of Monday?

Thanks!

Re: Week Start Day

swuehl — Fri, 13 Jul 2012 14:08:02 GMT

Some -- but not all -- QV date functions take as third optional argument a week (start) offset, like

weekstart(today(),0,-1)

should return last sunday's date.

Re: Week Start Day

Fri, 13 Jul 2012 15:26:08 GMT

However if you are trying to create a week number filed in your script you might want to try the following syntax: Week(weekstart(Date,0,-1)) Where Date is your date field Regards Rahul

Re: Week Start Day

swuehl — Fri, 13 Jul 2012 15:42:25 GMT

Rahul,

I think your created week number would be one off compared to WeekName(Date,0,-1).

As there are many different ways to define week numbering, I am not saying you're wrong, just want to express that we need to take care for the different way possible.

Since Meghan wants a week start on Sunday, I assume she also wants a week numbering different from the one based on ISO week numbering that week() or weekname() returns.

Re: Week Start Day

Fri, 13 Jul 2012 15:47:36 GMT

Thanks Swuehl!! have never used Weekname before, but would definately give it a try in my next app. Have a happy weekend! Regards Rahul