topic Financial Year Calendar in QlikView https://community.qlik.com/t5/QlikView/Financial-Year-Calendar/m-p/230733#M82545 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Has anyone got a Financial Calendar, I want one based on the financial period starting from April to March.</P><P></P><P>Thanks</P></BODY></HTML> Tue, 26 Apr 2011 22:35:07 GMT ivandrago 2011-04-26T22:35:07Z Financial Year Calendar https://community.qlik.com/t5/QlikView/Financial-Year-Calendar/m-p/230733#M82545 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Has anyone got a Financial Calendar, I want one based on the financial period starting from April to March.</P><P></P><P>Thanks</P></BODY></HTML> Tue, 26 Apr 2011 22:35:07 GMT https://community.qlik.com/t5/QlikView/Financial-Year-Calendar/m-p/230733#M82545 ivandrago 2011-04-26T22:35:07Z Financial Year Calendar https://community.qlik.com/t5/QlikView/Financial-Year-Calendar/m-p/230734#M82546 <HTML><HEAD></HEAD><BODY><P> You could try this:</P><P></P><P>Date:<BR />load<BR /> today()-recno()+1 as Date<BR />autogenerate(today()-'2008-01-01');</P><P><BR />DateParts:<BR />load<BR />yearname ( Date, 0, 4 )&nbsp; as FinancialYear<BR />resident Date;</P><P>Drop Table Date</P></BODY></HTML> Fri, 04 Nov 2011 15:19:30 GMT https://community.qlik.com/t5/QlikView/Financial-Year-Calendar/m-p/230734#M82546 2011-11-04T15:19:30Z