topic Expression help in QlikView https://community.qlik.com/t5/QlikView/Expression-help/m-p/669529#M1062013 <HTML><HEAD></HEAD><BODY><P>I have year like 11-12, 12-13, 13-14, 14-15</P><P></P><P>I want to show it like FY 12, FY 13, FY 14, FY 15</P><P></P><P>kindly help</P></BODY></HTML> Tue, 23 Sep 2014 07:57:40 GMT abhaysingh 2014-09-23T07:57:40Z Expression help https://community.qlik.com/t5/QlikView/Expression-help/m-p/669529#M1062013 <HTML><HEAD></HEAD><BODY><P>I have year like 11-12, 12-13, 13-14, 14-15</P><P></P><P>I want to show it like FY 12, FY 13, FY 14, FY 15</P><P></P><P>kindly help</P></BODY></HTML> Tue, 23 Sep 2014 07:57:40 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/669529#M1062013 abhaysingh 2014-09-23T07:57:40Z Re: Expression help https://community.qlik.com/t5/QlikView/Expression-help/m-p/669530#M1062014 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'FY ' &amp;SubField(YourYearField, '-',2) as NewYear</P></BODY></HTML> Tue, 23 Sep 2014 08:04:55 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/669530#M1062014 tresB 2014-09-23T08:04:55Z Re: Expression help https://community.qlik.com/t5/QlikView/Expression-help/m-p/669531#M1062015 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Look at this post</P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year">http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year</A></P><P><A href="https://community.qlik.com/docs/DOC-7094">Fiscal and Standard Calendar generation</A></P><P></P><P></P><P>regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 23 Sep 2014 08:05:35 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/669531#M1062015 ashfaq_haseeb 2014-09-23T08:05:35Z Re: Expression help https://community.qlik.com/t5/QlikView/Expression-help/m-p/669532#M1062016 <HTML><HEAD></HEAD><BODY><P>can I do it on front end??</P></BODY></HTML> Tue, 23 Sep 2014 08:07:54 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/669532#M1062016 abhaysingh 2014-09-23T08:07:54Z Re: Expression help https://community.qlik.com/t5/QlikView/Expression-help/m-p/669533#M1062017 <HTML><HEAD></HEAD><BODY><P>Yes you can.</P><P></P><P>Regards</P><P>KC</P></BODY></HTML> Tue, 23 Sep 2014 08:10:51 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/669533#M1062017 jyothish8807 2014-09-23T08:10:51Z Re: Expression help https://community.qlik.com/t5/QlikView/Expression-help/m-p/669534#M1062018 <HTML><HEAD></HEAD><BODY><P>HOW?</P></BODY></HTML> Tue, 23 Sep 2014 10:18:26 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/669534#M1062018 abhaysingh 2014-09-23T10:18:26Z Re: Expression help https://community.qlik.com/t5/QlikView/Expression-help/m-p/669535#M1062019 <HTML><HEAD></HEAD><BODY><P>same expression of tresesco</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.7272720336914px;">&nbsp; 'FY ' &amp;SubField(YourYearField, '-',2) </SPAN></P></BODY></HTML> Tue, 23 Sep 2014 10:23:24 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/669535#M1062019 maxgro 2014-09-23T10:23:24Z Re: Expression help https://community.qlik.com/t5/QlikView/Expression-help/m-p/669536#M1062020 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>write this as expression in a straight chart and name it as New Year</P><P></P><P>='FY ' &amp;SubField(YourYearField, '-',2)</P><P></P><P>Rgards</P><P>KC</P></BODY></HTML> Tue, 23 Sep 2014 11:12:51 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/669536#M1062020 jyothish8807 2014-09-23T11:12:51Z