How to convert Financial Year to Year format - Qlik Community

Report Inappropriate Content · ‎2012-09-04

Hi Folks,

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.

Regards,

Shree.

rajni_batra · ‎2012-09-04

what do u want in this 2001-2002 should be displayed as 2001

??

rajni_batra · ‎2012-09-04

you can use this kind of function if u want anything i mentioned above

=left([Financial Year],4)

Report Inappropriate Content · ‎2012-09-04

yes

Report Inappropriate Content · ‎2012-09-04

max year is shows as 2008 that is query

rajni_batra · ‎2012-09-04

no its showing 2007 when i used

=Left([Financial Year],4)

Report Inappropriate Content · ‎2012-09-04

Thanks for your valuable reply I got the answer.