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

Sunday as week start via expression or bookmark?

I was able to omit the current week in a rolling 13 weeks average without employing a master calendar script, So, I'm hoping there's a way to force Sunday to be the starting day of the week. I'm just not sure what search criteria would be used or what expression syntax is needed. Any ideas?

1 Solution

Accepted Solutions
Not applicable
Author

Try

"Week(Weekstart(TempDate,0,-1))"

Where TempDate is your date field.

Regards

RL

View solution in original post

3 Replies
Not applicable
Author

Try

"Week(Weekstart(TempDate,0,-1))"

Where TempDate is your date field.

Regards

RL

nagaiank
Specialist III
Specialist III

If you have a Date from which you are arriving at the week number, use Week(Date+1) or WeekName(Date+1) to get the week number, to start your week on Sundays.

Hope this helps.

Not applicable
Author

Perfect, lakhina - the chart dimension that worked was

=date(WeekStart(dev_finish_date,0,-1),'MMM-D')

Thank you!