topic Week function to work on Calender week in QlikView https://community.qlik.com/t5/QlikView/Week-function-to-work-on-Calender-week/m-p/210723#M65185 <HTML><HEAD></HEAD><BODY><P>OK, it sounds like you want your week to start on Sunday instead of on Monday? And you want your week numbers to start and end in each month?</P><P style="padding-left:30px;">1+ceil((Date-floor(weekend(monthstart(Date),0,-1)))/7) as "US Week but Start and End in Month"</P><P>See attached for the results.</P></BODY></HTML> Thu, 01 Jul 2010 22:23:58 GMT johnw 2010-07-01T22:23:58Z Week function to work on Calender week https://community.qlik.com/t5/QlikView/Week-function-to-work-on-Calender-week/m-p/210721#M65183 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have a MonthName, &amp; I wish to divide the month in 5 week's Week1, week2,..........Week5. But suppose if the month is Apr 2010 then it's first week :- has only 3 days since 1 st falls on Thursday. So I should get Month :- April 2010 Week :- Week1, WeekStartDate :- 01-Apr-2010 Week End Date :- 03-Apr-2010, Similarly Week2 Week2StartDate:- 04-Apr-2010 Week2EndDate:- 10-Apr-2010</P><P>and Week:- Week5 , WeekStart Date :- 25-Apr-2010 , WeekEndDate:- 30-Apr-2010.</P><P>If anyone knows how to do that for every month including feb please let me know. Thanks in advance.</P><P>With Regards</P><P>Amar</P><P></P></BODY></HTML> Thu, 01 Jul 2010 10:13:01 GMT https://community.qlik.com/t5/QlikView/Week-function-to-work-on-Calender-week/m-p/210721#M65183 amars 2010-07-01T10:13:01Z Week function to work on Calender week https://community.qlik.com/t5/QlikView/Week-function-to-work-on-Calender-week/m-p/210722#M65184 <HTML><HEAD></HEAD><BODY><P>I've attached something I've used...</P><P></P><P>You'd only need to name the first day of your range, and I presume the last one.</P><P>Not sure if this'll help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P></P></BODY></HTML> Thu, 01 Jul 2010 10:42:01 GMT https://community.qlik.com/t5/QlikView/Week-function-to-work-on-Calender-week/m-p/210722#M65184 2010-07-01T10:42:01Z Week function to work on Calender week https://community.qlik.com/t5/QlikView/Week-function-to-work-on-Calender-week/m-p/210723#M65185 <HTML><HEAD></HEAD><BODY><P>OK, it sounds like you want your week to start on Sunday instead of on Monday? And you want your week numbers to start and end in each month?</P><P style="padding-left:30px;">1+ceil((Date-floor(weekend(monthstart(Date),0,-1)))/7) as "US Week but Start and End in Month"</P><P>See attached for the results.</P></BODY></HTML> Thu, 01 Jul 2010 22:23:58 GMT https://community.qlik.com/t5/QlikView/Week-function-to-work-on-Calender-week/m-p/210723#M65185 johnw 2010-07-01T22:23:58Z