Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
WeekName(DateField, 0, -1) will give you Year/Week No. The -1 will offset the Monday to Sunday
Hope that helps
WeekName(DateField, 0, -1) will give you Year/Week No. The -1 will offset the Monday to Sunday
Hope that helps