How to create week numbers from dates

[#1]

Hi,

I have a file that outputs week numbers and its dates.

I can create week number etc from this for one part of the business but I need to use the date field and create other week numbers from the dates.

For example, Business A is fine as the information imported to qlikview contains both the week number and dates. (Mon - Sun)

Business B - I need to use the date field to create different week number because the week begins on different days (Sun - Sat)

Do you know how I can do this?

Gregg

[#2 · Accepted solution]

WeekName(DateField, 0, -1) will give you Year/Week No. The -1 will offset the Monday to Sunday

Hope that helps