topic How to convert Financial Year to Year format in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-Financial-Year-to-Year-format/m-p/383761#M143232 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Iam new to Qlikview. I need to convert Financial Year to Year format. How can i create. If i give max(year) it will shaow max year default. Plz Find my Attachments i Send sample .Xls and .qvw. Plz help me.</P><P></P><P></P><P></P><P></P><P>Regards,</P><P>Shree.</P></BODY></HTML> Tue, 04 Sep 2012 09:50:19 GMT 2012-09-04T09:50:19Z How to convert Financial Year to Year format https://community.qlik.com/t5/QlikView/How-to-convert-Financial-Year-to-Year-format/m-p/383761#M143232 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Iam new to Qlikview. I need to convert Financial Year to Year format. How can i create. If i give max(year) it will shaow max year default. Plz Find my Attachments i Send sample .Xls and .qvw. Plz help me.</P><P></P><P></P><P></P><P></P><P>Regards,</P><P>Shree.</P></BODY></HTML> Tue, 04 Sep 2012 09:50:19 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Financial-Year-to-Year-format/m-p/383761#M143232 2012-09-04T09:50:19Z Re: How to convert Financial Year to Year format https://community.qlik.com/t5/QlikView/How-to-convert-Financial-Year-to-Year-format/m-p/383762#M143233 <HTML><HEAD></HEAD><BODY><P>what do u want in this 2001-2002 should be displayed as 2001</P><P>??</P></BODY></HTML> Tue, 04 Sep 2012 10:40:17 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Financial-Year-to-Year-format/m-p/383762#M143233 rajni_batra 2012-09-04T10:40:17Z Re: How to convert Financial Year to Year format https://community.qlik.com/t5/QlikView/How-to-convert-Financial-Year-to-Year-format/m-p/383763#M143234 <HTML><HEAD></HEAD><BODY><P>you can use&nbsp; this kind of function if u want anything i mentioned above</P><P>=left([Financial Year],4)</P></BODY></HTML> Tue, 04 Sep 2012 10:43:40 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Financial-Year-to-Year-format/m-p/383763#M143234 rajni_batra 2012-09-04T10:43:40Z Re: How to convert Financial Year to Year format https://community.qlik.com/t5/QlikView/How-to-convert-Financial-Year-to-Year-format/m-p/383764#M143235 <HTML><HEAD></HEAD><BODY><P>yes</P></BODY></HTML> Tue, 04 Sep 2012 11:01:41 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Financial-Year-to-Year-format/m-p/383764#M143235 2012-09-04T11:01:41Z Re: How to convert Financial Year to Year format https://community.qlik.com/t5/QlikView/How-to-convert-Financial-Year-to-Year-format/m-p/383765#M143236 <HTML><HEAD></HEAD><BODY><P>max year is shows as 2008 that is query</P></BODY></HTML> Tue, 04 Sep 2012 11:02:53 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Financial-Year-to-Year-format/m-p/383765#M143236 2012-09-04T11:02:53Z Re: How to convert Financial Year to Year format https://community.qlik.com/t5/QlikView/How-to-convert-Financial-Year-to-Year-format/m-p/383766#M143237 <HTML><HEAD></HEAD><BODY><P>no its showing 2007 when i used </P><P>=Left([Financial Year],4)</P></BODY></HTML> Tue, 04 Sep 2012 11:13:00 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Financial-Year-to-Year-format/m-p/383766#M143237 rajni_batra 2012-09-04T11:13:00Z Re: How to convert Financial Year to Year format https://community.qlik.com/t5/QlikView/How-to-convert-Financial-Year-to-Year-format/m-p/383767#M143238 <HTML><HEAD></HEAD><BODY><P>Thanks for your valuable reply I got the answer.</P></BODY></HTML> Tue, 04 Sep 2012 11:20:07 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Financial-Year-to-Year-format/m-p/383767#M143238 2012-09-04T11:20:07Z