topic Re: Calendarweek in QlikView https://community.qlik.com/t5/QlikView/Calendarweek/m-p/336087#M123983 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If you require that all weeks start on first of January, you can use </P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>LunarWeekName(FieldDate) AS Week</P></PRE><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Mon, 04 Jun 2012 14:40:20 GMT Miguel_Angel_Baeyens 2012-06-04T14:40:20Z Calendarweek https://community.qlik.com/t5/QlikView/Calendarweek/m-p/336086#M123982 <HTML><HEAD></HEAD><BODY><P>1-01-2012 = week 52 and i most be week1</P><P></P><P>can someone help me ?</P></BODY></HTML> Mon, 04 Jun 2012 14:32:56 GMT https://community.qlik.com/t5/QlikView/Calendarweek/m-p/336086#M123982 2012-06-04T14:32:56Z Re: Calendarweek https://community.qlik.com/t5/QlikView/Calendarweek/m-p/336087#M123983 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If you require that all weeks start on first of January, you can use </P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>LunarWeekName(FieldDate) AS Week</P></PRE><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Mon, 04 Jun 2012 14:40:20 GMT https://community.qlik.com/t5/QlikView/Calendarweek/m-p/336087#M123983 Miguel_Angel_Baeyens 2012-06-04T14:40:20Z