topic Re: Convert week in month in QlikView https://community.qlik.com/t5/QlikView/Convert-week-in-month/m-p/675198#M1057583 <HTML><HEAD></HEAD><BODY><P>=Month(MakeWeekDate(2014,<STRONG>Week_no</STRONG>,1)+1)</P></BODY></HTML> Tue, 07 Oct 2014 15:26:21 GMT anbu1984 2014-10-07T15:26:21Z Convert week in month https://community.qlik.com/t5/QlikView/Convert-week-in-month/m-p/675197#M1057581 <HTML><HEAD></HEAD><BODY><P>Hi gays,</P><P>It's possible to know which month is one week</P><P></P><P>For example: Week1 = January</P><P>Thanks you !!!</P></BODY></HTML> Tue, 07 Oct 2014 15:20:26 GMT https://community.qlik.com/t5/QlikView/Convert-week-in-month/m-p/675197#M1057581 fabio182 2014-10-07T15:20:26Z Re: Convert week in month https://community.qlik.com/t5/QlikView/Convert-week-in-month/m-p/675198#M1057583 <HTML><HEAD></HEAD><BODY><P>=Month(MakeWeekDate(2014,<STRONG>Week_no</STRONG>,1)+1)</P></BODY></HTML> Tue, 07 Oct 2014 15:26:21 GMT https://community.qlik.com/t5/QlikView/Convert-week-in-month/m-p/675198#M1057583 anbu1984 2014-10-07T15:26:21Z Re: Convert week in month https://community.qlik.com/t5/QlikView/Convert-week-in-month/m-p/675199#M1057584 <HTML><HEAD></HEAD><BODY><P>you need an year and a week number</P><P>then you can use month and makeweekdate (replace with your field)</P><P></P><P>=month(makeweekdate(1999,6))</P></BODY></HTML> Tue, 07 Oct 2014 15:27:25 GMT https://community.qlik.com/t5/QlikView/Convert-week-in-month/m-p/675199#M1057584 maxgro 2014-10-07T15:27:25Z Re: Convert week in month https://community.qlik.com/t5/QlikView/Convert-week-in-month/m-p/675200#M1057585 <HTML><HEAD></HEAD><BODY><P>Thank you so much Massino !!!</P></BODY></HTML> Tue, 07 Oct 2014 15:41:03 GMT https://community.qlik.com/t5/QlikView/Convert-week-in-month/m-p/675200#M1057585 fabio182 2014-10-07T15:41:03Z