topic Re: Replacing 20 with FY in QlikView https://community.qlik.com/t5/QlikView/Replacing-20-with-FY/m-p/74333#M788244 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P><STRONG>'FY' &amp; Right(Year, 2) as FYear</STRONG></P></BODY></HTML> Thu, 22 Feb 2018 17:18:06 GMT sunny_talwar 2018-02-22T17:18:06Z Replacing 20 with FY https://community.qlik.com/t5/QlikView/Replacing-20-with-FY/m-p/74332#M788243 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I have year values as 2019 , and 2020 .. i need them to be displayed FY19,FY20 .. using replace function i am getting FYFY for 2020 .. how do i avoid this?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Replacing-20-with-FY/m-p/74332#M788243 stevejones1 2020-11-25T16:16:04Z Re: Replacing 20 with FY https://community.qlik.com/t5/QlikView/Replacing-20-with-FY/m-p/74333#M788244 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P><STRONG>'FY' &amp; Right(Year, 2) as FYear</STRONG></P></BODY></HTML> Thu, 22 Feb 2018 17:18:06 GMT https://community.qlik.com/t5/QlikView/Replacing-20-with-FY/m-p/74333#M788244 sunny_talwar 2018-02-22T17:18:06Z Re: Replacing 20 with FY https://community.qlik.com/t5/QlikView/Replacing-20-with-FY/m-p/74334#M788247 <HTML><HEAD></HEAD><BODY><P>You can do it by Right function..</P><P>'FY' &amp; Right(YearField,2) as YearField</P></BODY></HTML> Thu, 22 Feb 2018 17:23:58 GMT https://community.qlik.com/t5/QlikView/Replacing-20-with-FY/m-p/74334#M788247 shiveshsingh 2018-02-22T17:23:58Z