topic Re: Week() Function in QlikView

Week() Function

ciaran_mcgowan — Thu, 03 Apr 2014 15:50:56 GMT

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.

Re: Week() Function

alexandros17 — Thu, 03 Apr 2014 15:59:11 GMT

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

Re: Week() Function

Nicole-Smith — Thu, 03 Apr 2014 17:21:13 GMT

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