topic Re: Fiscal Month in QlikView https://community.qlik.com/t5/QlikView/Fiscal-Month/m-p/1171052#M633209 <HTML><HEAD></HEAD><BODY><P>"<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">give the month number of monday's date -1 "</SPAN></P><P></P><P>Do you want to actually the month number of Sunday (Month(Monday's date -1)), or do you want to range your month numbers from 0 to 11 ((month number of Monday's date)-1) ?</P><P></P><P>Maybe like this (assuming weekstart is defined as Monday):</P><P></P><P>Month( WeekStart( DateField) -1) AS MonthField</P><P></P><P>or</P><P></P><P>Month(WeekStart(DateField))-1 AS MonthField</P></BODY></HTML> Fri, 10 Jun 2016 21:52:17 GMT swuehl 2016-06-10T21:52:17Z Fiscal Month https://community.qlik.com/t5/QlikView/Fiscal-Month/m-p/1171051#M633208 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm trying to generate Fiscal month based on Fiscal week.</P><P></P><P>1.&nbsp;&nbsp;&nbsp;&nbsp; check monday of every week&nbsp; - give the month number of monday's date -1&nbsp; as fiscal month for the date</P><P>Can someone please help?</P><P></P><P>Any help is highly appreciated.</P></BODY></HTML> Fri, 10 Jun 2016 18:34:15 GMT https://community.qlik.com/t5/QlikView/Fiscal-Month/m-p/1171051#M633208 markgraham123 2016-06-10T18:34:15Z Re: Fiscal Month https://community.qlik.com/t5/QlikView/Fiscal-Month/m-p/1171052#M633209 <HTML><HEAD></HEAD><BODY><P>"<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">give the month number of monday's date -1 "</SPAN></P><P></P><P>Do you want to actually the month number of Sunday (Month(Monday's date -1)), or do you want to range your month numbers from 0 to 11 ((month number of Monday's date)-1) ?</P><P></P><P>Maybe like this (assuming weekstart is defined as Monday):</P><P></P><P>Month( WeekStart( DateField) -1) AS MonthField</P><P></P><P>or</P><P></P><P>Month(WeekStart(DateField))-1 AS MonthField</P></BODY></HTML> Fri, 10 Jun 2016 21:52:17 GMT https://community.qlik.com/t5/QlikView/Fiscal-Month/m-p/1171052#M633209 swuehl 2016-06-10T21:52:17Z