topic how to make special week in QlikView

how to make special week

Mon, 13 Apr 2015 01:56:47 GMT

Dear all

we want to get the week number of date, in qlikview, the week function can get the general week define, that means, the week is start from Monday to Sunday.

now we has special week define, one week start from Friday 6:00a.m to next Friday 6a.m . can we do something to change the week define then we can use the WEEK Function , or can we use other method to realize this?

thanks for your share.

Re: how to make special week

Mon, 13 Apr 2015 03:25:35 GMT

Week Start - Sunday instead of Monday

Re: how to make special week

petter — Mon, 13 Apr 2015 03:40:12 GMT

You should make use of the different Week-functions where you can specify WeekOffset to get the adjustment you want. No you cant adjust an option to change the weekstart calculations in one go.