topic Re: how to write expression in QlikView https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1111734#M463827 <HTML><HEAD></HEAD><BODY><P>Hi Naveen,</P><P>It might be work.</P><P>Please check this attachment.</P></BODY></HTML> Thu, 02 Jun 2016 04:56:22 GMT susovan 2016-06-02T04:56:22Z how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1111731#M463824 <HTML><HEAD></HEAD><BODY><P>Hello&nbsp; All,</P><P></P><P>this is my expression to get&nbsp; financial year ,which is working great</P><P></P><P></P><P> <STRONG style="font-size: 12pt;">'FY'&amp;year(AddYears(yearstart (ENSTEHDAT, 1, 4),-1)) &amp;'-'&amp;Year(yearstart (ENSTEHDAT, 1, 4)) as Year</STRONG></P><P><STRONG style="font-size: 12pt;"><BR /></STRONG></P><P>this is what i am getting </P><P></P><P>ESTEHDAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Year</P><P>10/29/2003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FY2003-2004</P><P></P><P>what i am looking is this</P><P></P><P><SPAN style="font-size: 13.3333px;">ESTEHDAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Year</SPAN></P><P><SPAN style="font-size: 13.3333px; line-height: 1.5em;">10/29/2003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FY03-04</SPAN></P><P><SPAN style="font-size: 13.3333px; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px; line-height: 1.5em;">how to get only two values from year fiels<BR /></SPAN></P></BODY></HTML> Thu, 02 Jun 2016 04:31:46 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1111731#M463824 kunkumnaveen 2016-06-02T04:31:46Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1111732#M463825 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try this,</P><P></P><P><STRONG style="font-size: 12pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">'FY'&amp;Date(AddYears(yearstart (ENSTEHDAT, 1, 4),-1),'YY') &amp;'-'&amp;Date(yearstart (ENSTEHDAT, 1, 4),'YY') as Year</STRONG></P><P><STRONG style="font-size: 12pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></STRONG></P><P><STRONG style="font-size: 12pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">-Joyson G<BR /></STRONG></P></BODY></HTML> Thu, 02 Jun 2016 04:36:00 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1111732#M463825 2016-06-02T04:36:00Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1111733#M463826 <HTML><HEAD></HEAD><BODY><P><EM>Try this,</EM></P><P></P><P><EM>'FY'&amp; Date(AddYears(yearstart (ENSTEHDAT, 1, 4),-1),'YY')&nbsp; &amp;'-'&amp; Date(yearstart (ENSTEHDAT, 1, 4),'YY') as Year</EM></P></BODY></HTML> Thu, 02 Jun 2016 04:41:19 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1111733#M463826 tamilarasu 2016-06-02T04:41:19Z Re: how to write expression https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1111734#M463827 <HTML><HEAD></HEAD><BODY><P>Hi Naveen,</P><P>It might be work.</P><P>Please check this attachment.</P></BODY></HTML> Thu, 02 Jun 2016 04:56:22 GMT https://community.qlik.com/t5/QlikView/how-to-write-expression/m-p/1111734#M463827 susovan 2016-06-02T04:56:22Z