topic Re: NEW YEAR REQUIREMENT in QlikView https://community.qlik.com/t5/QlikView/NEW-YEAR-REQUIREMENT/m-p/53668#M790962 <HTML><HEAD></HEAD><BODY><P>from every year from 1986 to 2050</P></BODY></HTML> Mon, 05 Feb 2018 15:24:00 GMT manu1512 2018-02-05T15:24:00Z NEW YEAR REQUIREMENT https://community.qlik.com/t5/QlikView/NEW-YEAR-REQUIREMENT/m-p/53664#M790958 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a requirement where we want to have year from september to august.Can any one tell us how to do?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/NEW-YEAR-REQUIREMENT/m-p/53664#M790958 manu1512 2020-11-25T16:16:04Z Re: NEW YEAR REQUIREMENT https://community.qlik.com/t5/QlikView/NEW-YEAR-REQUIREMENT/m-p/53665#M790959 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>you are talking about reload (script) ? or on some analysis (expressions) ??</P></BODY></HTML> Mon, 05 Feb 2018 14:56:53 GMT https://community.qlik.com/t5/QlikView/NEW-YEAR-REQUIREMENT/m-p/53665#M790959 YoussefBelloum 2018-02-05T14:56:53Z Re: NEW YEAR REQUIREMENT https://community.qlik.com/t5/QlikView/NEW-YEAR-REQUIREMENT/m-p/53666#M790960 <HTML><HEAD></HEAD><BODY><P>What year is that? Perhaps this?</P><P></P><P><STRONG>Load *, If(Year = 2017 and (Month &gt;= 'september' and Month &lt;= 'august'), 1,0) as Flag;</STRONG></P><P><STRONG>Load Year(Date) as Year,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date(Month(Date), 'MMMM') as Month</STRONG></P><P><STRONG>From Table;</STRONG></P></BODY></HTML> Mon, 05 Feb 2018 14:58:13 GMT https://community.qlik.com/t5/QlikView/NEW-YEAR-REQUIREMENT/m-p/53666#M790960 Anil_Babu_Samineni 2018-02-05T14:58:13Z Re: NEW YEAR REQUIREMENT https://community.qlik.com/t5/QlikView/NEW-YEAR-REQUIREMENT/m-p/53667#M790961 <HTML><HEAD></HEAD><BODY><P>from script yusuf</P></BODY></HTML> Mon, 05 Feb 2018 15:23:32 GMT https://community.qlik.com/t5/QlikView/NEW-YEAR-REQUIREMENT/m-p/53667#M790961 manu1512 2018-02-05T15:23:32Z Re: NEW YEAR REQUIREMENT https://community.qlik.com/t5/QlikView/NEW-YEAR-REQUIREMENT/m-p/53668#M790962 <HTML><HEAD></HEAD><BODY><P>from every year from 1986 to 2050</P></BODY></HTML> Mon, 05 Feb 2018 15:24:00 GMT https://community.qlik.com/t5/QlikView/NEW-YEAR-REQUIREMENT/m-p/53668#M790962 manu1512 2018-02-05T15:24:00Z Re: NEW YEAR REQUIREMENT https://community.qlik.com/t5/QlikView/NEW-YEAR-REQUIREMENT/m-p/53669#M790963 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlikview.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year" title="https://community.qlikview.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year">Qlik Design Blog : Fiscal Year | Qlik Community</A></P></BODY></HTML> Mon, 05 Feb 2018 15:32:09 GMT https://community.qlik.com/t5/QlikView/NEW-YEAR-REQUIREMENT/m-p/53669#M790963 m_woolf 2018-02-05T15:32:09Z Re: NEW YEAR REQUIREMENT https://community.qlik.com/t5/QlikView/NEW-YEAR-REQUIREMENT/m-p/53670#M790964 <HTML><HEAD></HEAD><BODY><P>You can use where condition to restrict the data like my month condition?</P></BODY></HTML> Tue, 06 Feb 2018 00:31:17 GMT https://community.qlik.com/t5/QlikView/NEW-YEAR-REQUIREMENT/m-p/53670#M790964 Anil_Babu_Samineni 2018-02-06T00:31:17Z Re: NEW YEAR REQUIREMENT https://community.qlik.com/t5/QlikView/NEW-YEAR-REQUIREMENT/m-p/53671#M790965 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-7094">Fiscal and Standard Calendar generation</A></P></BODY></HTML> Tue, 06 Feb 2018 01:01:18 GMT https://community.qlik.com/t5/QlikView/NEW-YEAR-REQUIREMENT/m-p/53671#M790965 Siva_Sankar 2018-02-06T01:01:18Z