Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Sunday as week start via expression or bookmark?

Try

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

Where TempDate is your date field.

Regards

RL

3 Replies
Not applicable

Re: Sunday as week start via expression or bookmark?

Try

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

Where TempDate is your date field.

Regards

RL

nagaiank
Valued Contributor III

Re: Sunday as week start via expression or bookmark?

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

Re: Sunday as week start via expression or bookmark?

Perfect, lakhina - the chart dimension that worked was

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

Thank you!

Community Browser