topic Re: Setting a deviating start of the week in QlikView

Setting a deviating start of the week

datanibbler — Fri, 16 Jan 2015 09:29:27 GMT

Hi,

I know there have been a nr. of discussions here about deviating fiscal years.

I wonder, is it also possible for weeks - to define a deviating start_day - in this instance, a week should start on Thursday and run till Wednesday. The calendar_week would then be different, too - a few days of every cw would be moved into the one before, so to speak.

Is it possible to generate a calendar - only for that specific purpose, so I wouldn't touch the master_calendar - that has this deviating week_structure?

Thanks a lot!

Best regards,

DataNibbler

Re: Setting a deviating start of the week

Gysbert_Wassenaar — Fri, 16 Jan 2015 09:37:38 GMT

See this blog post: Redefining the Week Start

And perhaps this one too: Redefining the Week Numbers

Re: Setting a deviating start of the week

Fri, 16 Jan 2015 09:40:28 GMT

Hi Data,

the InWeek function allows for an optional weekstart offset to be entered, should be able to create a flag from this for use in your master calendar (or outside as you say).

Same with weekstart & weekend, all allow the offset.

Hope that helps

Joe

Re: Setting a deviating start of the week

datanibbler — Fri, 16 Jan 2015 09:47:10 GMT

Hi Gysbert,

many thanks!

The Weekstart() function and its offset_parameter are just what I discovered just now in the integrated help. It is very relieving to see that the pros suggest just that.

You can define the calendar_week and everything else based on that - it's only slightly more typing as you always need that offset - with functions that don't have one, you have to nest the Weekstart() function inside to have it.

Best regards,

DataNibbler

Re: Setting a deviating start of the week

datanibbler — Fri, 16 Jan 2015 09:48:02 GMT

Hi Joe,

yes, that's what I found in the integrated help and I'm relieved to see that the pros in their design_blogs suggest nothing else.

Thanks a lot!

Best regards,

DataNibbler