topic Week of month in QlikView https://community.qlik.com/t5/QlikView/Week-of-month/m-p/205610#M62016 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You could also try Day(Today()-1)/7 + 1</P><P>Just replace Today() with the date from which you want the week</P><P>Regards.</P><P></P><P></P><P></P><P></P></BODY></HTML> Tue, 08 Feb 2011 16:38:42 GMT 2011-02-08T16:38:42Z Week of month https://community.qlik.com/t5/QlikView/Week-of-month/m-p/205608#M62014 <HTML><HEAD></HEAD><BODY><P>HI people</P><P>I need week of month expretion...Im still very new at Qlikview and realy need help...</P><P>Thanx for any help u can offer...</P></BODY></HTML> Tue, 08 Feb 2011 15:01:33 GMT https://community.qlik.com/t5/QlikView/Week-of-month/m-p/205608#M62014 stevietm 2011-02-08T15:01:33Z Week of month https://community.qlik.com/t5/QlikView/Week-of-month/m-p/205609#M62015 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>Try In the script load:</P><P>week(Date) as nWeek</P><P>Regards.</P></BODY></HTML> Tue, 08 Feb 2011 16:24:13 GMT https://community.qlik.com/t5/QlikView/Week-of-month/m-p/205609#M62015 spividori 2011-02-08T16:24:13Z Week of month https://community.qlik.com/t5/QlikView/Week-of-month/m-p/205610#M62016 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You could also try Day(Today()-1)/7 + 1</P><P>Just replace Today() with the date from which you want the week</P><P>Regards.</P><P></P><P></P><P></P><P></P></BODY></HTML> Tue, 08 Feb 2011 16:38:42 GMT https://community.qlik.com/t5/QlikView/Week-of-month/m-p/205610#M62016 2011-02-08T16:38:42Z Week of month https://community.qlik.com/t5/QlikView/Week-of-month/m-p/205611#M62017 <HTML><HEAD></HEAD><BODY><P>Just write in the script</P><P>If day(Date)&lt;8, W1, IF(Day(Date)&lt;15, W2, IF(Day(Date)&lt;22, W3, W4 ))) as WeekofMonth</P><P>Just check the parentheses!</P></BODY></HTML> Tue, 08 Feb 2011 16:55:13 GMT https://community.qlik.com/t5/QlikView/Week-of-month/m-p/205611#M62017 2011-02-08T16:55:13Z Week of month https://community.qlik.com/t5/QlikView/Week-of-month/m-p/205612#M62018 <HTML><HEAD></HEAD><BODY><P>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:</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"<BR />,1+ceil((Date-floor(weekend(monthstart(Date))))/7) as "ISO Week but Start and End in Month"</P></BODY></HTML> Wed, 09 Feb 2011 00:58:39 GMT https://community.qlik.com/t5/QlikView/Week-of-month/m-p/205612#M62018 johnw 2011-02-09T00:58:39Z Week of month https://community.qlik.com/t5/QlikView/Week-of-month/m-p/205613#M62019 <HTML><HEAD></HEAD><BODY><P> Depende mucho de cómo lo necesites.</P></BODY></HTML> Wed, 25 Apr 2012 15:57:01 GMT https://community.qlik.com/t5/QlikView/Week-of-month/m-p/205613#M62019 2012-04-25T15:57:01Z