topic Fiscal Year 6 months in QlikView https://community.qlik.com/t5/QlikView/Fiscal-Year-6-months/m-p/1318840#M840681 <HTML><HEAD></HEAD><BODY><P>I have a formula that brings in the Fiscal Year Month for the last 6 months.</P><P></P><P>Right now, I am showing Nov-(start of) May.</P><P></P><P>What I want to do is show as far as the very end of April and not include May.</P><P></P><P>I have a variable vFiscalYearMonth6Months</P><P></P><P>=num(addmonths(MonthStart(today()),-6)) which brings in Nov until the start of May.</P><P></P><P>Any ideas how to remove May?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT bobbydave 2020-11-25T16:16:04Z Fiscal Year 6 months https://community.qlik.com/t5/QlikView/Fiscal-Year-6-months/m-p/1318840#M840681 <HTML><HEAD></HEAD><BODY><P>I have a formula that brings in the Fiscal Year Month for the last 6 months.</P><P></P><P>Right now, I am showing Nov-(start of) May.</P><P></P><P>What I want to do is show as far as the very end of April and not include May.</P><P></P><P>I have a variable vFiscalYearMonth6Months</P><P></P><P>=num(addmonths(MonthStart(today()),-6)) which brings in Nov until the start of May.</P><P></P><P>Any ideas how to remove May?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Fiscal-Year-6-months/m-p/1318840#M840681 bobbydave 2020-11-25T16:16:04Z Re: Fiscal Year 6 months https://community.qlik.com/t5/QlikView/Fiscal-Year-6-months/m-p/1318841#M840682 <HTML><HEAD></HEAD><BODY><P>Is this used in script or set analysis? Can you share the where statement or the expression where this variable is used?</P></BODY></HTML> Wed, 10 May 2017 14:59:58 GMT https://community.qlik.com/t5/QlikView/Fiscal-Year-6-months/m-p/1318841#M840682 sunny_talwar 2017-05-10T14:59:58Z