Week() Function

[ciaran_mcgowan]

Hi,

Is there any way to change the week() function so that my week #1 occurs on a set date each year instead of January 1st?

I have a series of files where week 1 should equal the first date in the excel file and the last week should equal the last date in the file. Each file only contains 6 months worth of dates so there should only be 26 weeks per year (ignoring weeks 27-52/53). The start dates vary slightly but usually occur around mid November each year and end in mid April.

Thanks.

[alexandros17]

It is only an idea but

1) assign the correct week to the dates you have then

2) recompute them from 1 to max so you will have the ordering you need

[Nicole-Smith]

See this blog post: http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/27/week-numbers