topic Re: how to create week field by using monthyear field in QlikView https://community.qlik.com/t5/QlikView/how-to-create-week-field-by-using-monthyear-field/m-p/419255#M156000 <HTML><HEAD></HEAD><BODY><P>it is not working</P><P></P><P></P><P>i am using this </P><P> WeekName([ Date], 0, -1) as Week,</P><P></P><P>by this i am getting the week numbers and year but i need only week numbers year should not be shown</P></BODY></HTML> Thu, 07 Mar 2013 16:52:59 GMT 2013-03-07T16:52:59Z how to create week field by using monthyear field https://community.qlik.com/t5/QlikView/how-to-create-week-field-by-using-monthyear-field/m-p/419253#M155998 <HTML><HEAD></HEAD><BODY><P>i am having a field monthyear which shows 201302&nbsp;&nbsp; yearmonth</P><P></P><P></P><P>by using this field i have to create week numbers </P><P>can anyone help me</P></BODY></HTML> Thu, 07 Mar 2013 16:17:10 GMT https://community.qlik.com/t5/QlikView/how-to-create-week-field-by-using-monthyear-field/m-p/419253#M155998 2013-03-07T16:17:10Z Re: how to create week field by using monthyear field https://community.qlik.com/t5/QlikView/how-to-create-week-field-by-using-monthyear-field/m-p/419254#M155999 <HTML><HEAD></HEAD><BODY><P></P><P>Hi,</P><P></P><P>Try like this</P><P></P><P>=Week(MakeDate(Left(YearMonth), Right(2)))</P><P></P><P>Hope this helps you.</P><P></P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 07 Mar 2013 16:43:51 GMT https://community.qlik.com/t5/QlikView/how-to-create-week-field-by-using-monthyear-field/m-p/419254#M155999 jagan 2013-03-07T16:43:51Z Re: how to create week field by using monthyear field https://community.qlik.com/t5/QlikView/how-to-create-week-field-by-using-monthyear-field/m-p/419255#M156000 <HTML><HEAD></HEAD><BODY><P>it is not working</P><P></P><P></P><P>i am using this </P><P> WeekName([ Date], 0, -1) as Week,</P><P></P><P>by this i am getting the week numbers and year but i need only week numbers year should not be shown</P></BODY></HTML> Thu, 07 Mar 2013 16:52:59 GMT https://community.qlik.com/t5/QlikView/how-to-create-week-field-by-using-monthyear-field/m-p/419255#M156000 2013-03-07T16:52:59Z