Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
we want to get the week number of date, in qlikview, the week function can get the general week define, that means, the week is start from Monday to Sunday.
now we has special week define, one week start from Friday 6:00a.m to next Friday 6a.m . can we do something to change the week define then we can use the WEEK Function , or can we use other method to realize this?
thanks for your share.
You should make use of the different Week-functions where you can specify WeekOffset to get the adjustment you want. No you cant adjust an option to change the weekstart calculations in one go.