topic Creating Financial year format -2011/12 etc. in QlikView https://community.qlik.com/t5/QlikView/Creating-Financial-year-format-2011-12-etc/m-p/312540#M707425 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt; font-family: arial,helvetica,sans-serif;"></SPAN></P><P><SPAN style="font-family: arial,helvetica,sans-serif; font-size: 12pt;">I am using the following piece of code to calculate financial year</SPAN></P><P><SPAN style="font-size: 12pt; font-family: arial,helvetica,sans-serif;"></SPAN></P><P></P><P><IMG alt="calendar.bmp" class="jive-image" src="https://community.qlik.com/legacyfs/online/11587_calendar.bmp" /></P><P></P><P></P><P></P><SPAN style="font-family: arial,helvetica,sans-serif;"><P></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P><SPAN style="font-size: 14pt;">For example. This displays 2011 for any date between April 2011 and April 2012</SPAN></P></SPAN><P></P><P></P><P></P><P><SPAN style="font-size: 8pt; font-family: arial,helvetica,sans-serif;"></SPAN></P><P></P><P><SPAN style="font-size: 14pt;">However I would like the date to display: 2010/11,&nbsp; 2011/12, 2012/13 etc</SPAN></P><P></P><SPAN style="font-size: 8pt; font-family: arial,helvetica,sans-serif;"><P><SPAN style="font-size: 8pt;"></SPAN></P><P></P><P><SPAN style="font-size: 8pt;">I would appricate any help anyone has with this</SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P></P><SPAN style="font-size: 8pt; font-family: arial,helvetica,sans-serif;"><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P></P></SPAN><P></P><P></P><P></P></SPAN><P></P></BODY></HTML> Thu, 23 Feb 2012 11:15:50 GMT 2012-02-23T11:15:50Z Creating Financial year format -2011/12 etc. https://community.qlik.com/t5/QlikView/Creating-Financial-year-format-2011-12-etc/m-p/312540#M707425 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt; font-family: arial,helvetica,sans-serif;"></SPAN></P><P><SPAN style="font-family: arial,helvetica,sans-serif; font-size: 12pt;">I am using the following piece of code to calculate financial year</SPAN></P><P><SPAN style="font-size: 12pt; font-family: arial,helvetica,sans-serif;"></SPAN></P><P></P><P><IMG alt="calendar.bmp" class="jive-image" src="https://community.qlik.com/legacyfs/online/11587_calendar.bmp" /></P><P></P><P></P><P></P><SPAN style="font-family: arial,helvetica,sans-serif;"><P></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P><SPAN style="font-size: 14pt;">For example. This displays 2011 for any date between April 2011 and April 2012</SPAN></P></SPAN><P></P><P></P><P></P><P><SPAN style="font-size: 8pt; font-family: arial,helvetica,sans-serif;"></SPAN></P><P></P><P><SPAN style="font-size: 14pt;">However I would like the date to display: 2010/11,&nbsp; 2011/12, 2012/13 etc</SPAN></P><P></P><SPAN style="font-size: 8pt; font-family: arial,helvetica,sans-serif;"><P><SPAN style="font-size: 8pt;"></SPAN></P><P></P><P><SPAN style="font-size: 8pt;">I would appricate any help anyone has with this</SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P></P><SPAN style="font-size: 8pt; font-family: arial,helvetica,sans-serif;"><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P></P></SPAN><P></P><P></P><P></P></SPAN><P></P></BODY></HTML> Thu, 23 Feb 2012 11:15:50 GMT https://community.qlik.com/t5/QlikView/Creating-Financial-year-format-2011-12-etc/m-p/312540#M707425 2012-02-23T11:15:50Z Creating Financial year format -2011/12 etc. https://community.qlik.com/t5/QlikView/Creating-Financial-year-format-2011-12-etc/m-p/312541#M707426 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp; you can use with Yearname(TempDate,0,4) as Fin_Yr.</P><P></P><P>It will give you the date field as 2011-2012,2010-2011..etc</P><P></P><P></P><P>-Jai</P></BODY></HTML> Thu, 23 Feb 2012 11:17:53 GMT https://community.qlik.com/t5/QlikView/Creating-Financial-year-format-2011-12-etc/m-p/312541#M707426 2012-02-23T11:17:53Z