Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Week number, weekstart and week range issues

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:

Table.jpg

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!

1 Reply
dennisnet
Valued Contributor III

Week number, weekstart and week range issues

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.