Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI people
I need week of month expretion...Im still very new at Qlikview and realy need help...
Thanx for any help u can offer...
There are a lot of very different things that "week of month" can mean. There are therefore a lot of possible answers. Here are a couple more possibilities from a working example application:
,1+ceil((Date-floor(weekend(monthstart(Date),0,-1)))/7) as "US Week but Start and End in Month"
,1+ceil((Date-floor(weekend(monthstart(Date))))/7) as "ISO Week but Start and End in Month"
Hi.
Try In the script load:
week(Date) as nWeek
Regards.
Hi,
You could also try Day(Today()-1)/7 + 1
Just replace Today() with the date from which you want the week
Regards.
Just write in the script
If day(Date)<8, W1, IF(Day(Date)<15, W2, IF(Day(Date)<22, W3, W4 ))) as WeekofMonth
Just check the parentheses!
There are a lot of very different things that "week of month" can mean. There are therefore a lot of possible answers. Here are a couple more possibilities from a working example application:
,1+ceil((Date-floor(weekend(monthstart(Date),0,-1)))/7) as "US Week but Start and End in Month"
,1+ceil((Date-floor(weekend(monthstart(Date))))/7) as "ISO Week but Start and End in Month"
Depende mucho de cómo lo necesites.