Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Week Start Day

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!

4 Replies
swuehl
MVP
MVP

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.

Not applicable
Author

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

swuehl
MVP
MVP

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.

Not applicable
Author

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