Week number, weekstart and week range issues

Tue, 03 Apr 2012 18:57:48 GMT

Hey All-

Having some issues trying to get week #s, week start and week ranges (user created date field) all in sync. Wondering if someone could help assist?

Take a look at this table:

Note how the WeekStart, CalendarDate are inline, but the CalendarWeek, and WeekRange are not.

I believe the issue stems from the difference between Week #s and weekstart, but I'm not entirely sure. I've attached an example QVW.

Is there anyway to resolve this and have them in line?

Thanks!

Anonymous — Wed, 04 Apr 2012 13:09:26 GMT

I think I found it.

In our week# the first day of the week is on Monday

and in your WeekStart the first day of the week is on Sunday

Try :

Week((TempDate)+1) AS CalendarWeek,

This way the Week# also starts on Sunday.

topic Week number, weekstart and week range issues in QlikView