topic Re: Need help on update Fiscal year in QlikView https://community.qlik.com/t5/QlikView/Need-help-on-update-Fiscal-year/m-p/845971#M297013 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>What i want is ?</P><P>I have like this &gt;&gt;</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 148px;"><TBODY><TR><TD class="xl63" height="17" width="148">2012-2013</TD></TR><TR><TD class="xl63" height="17">2013-2014</TD></TR><TR><TD class="xl63" height="17"><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="161" style="width: 153px; height: 165px;" width="153"><TBODY><TR><TD class="xl63" height="17" width="148">2012-2013</TD></TR><TR><TD class="xl63" height="17">2013-2014</TD></TR><TR><TD class="xl63" height="17">2014-2015</TD></TR><TR><TD class="xl63" height="17">2015-2016</TD></TR><TR><TD class="xl63" height="17">2016-2017</TD></TR></TBODY></TABLE></TD></TR><TR><TD class="xl63" height="17">2016-2017</TD></TR></TBODY></TABLE><P></P><P>My requirement is </P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 148px;"><TBODY><TR><TD class="xl63" height="17" width="148"></TD></TR><TR><TD class="xl63" height="17">2014-2015</TD></TR><TR><TD class="xl63" height="17">2015-2016</TD></TR><TR><TD class="xl63" height="17"></TD></TR></TBODY></TABLE><P>I want above two only.How do i do ?</P><P></P><P></P><P></P><P>Regards,</P><P>Nagarjua</P></BODY></HTML> Wed, 29 Apr 2015 09:34:49 GMT nagarjuna_kotha 2015-04-29T09:34:49Z Need help on update Fiscal year https://community.qlik.com/t5/QlikView/Need-help-on-update-Fiscal-year/m-p/845967#M297009 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I need help on <SPAN style="color: #222222; font-family: arial, sans-serif; font-size: 12.8000001907349px;">update Fiscal year 2014-2015 and 2015-2016.</SPAN></P><P></P><P>Can anyone help me on this ASAP&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;Its urgent..</P><P></P><P></P><P></P><P>Regards,</P><P>Nagarjuna</P></BODY></HTML> Wed, 29 Apr 2015 05:57:28 GMT https://community.qlik.com/t5/QlikView/Need-help-on-update-Fiscal-year/m-p/845967#M297009 nagarjuna_kotha 2015-04-29T05:57:28Z Re: Need help on update Fiscal year https://community.qlik.com/t5/QlikView/Need-help-on-update-Fiscal-year/m-p/845968#M297010 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>USe YearName(DateField,0,4)</P><P></P><P>If financial year start from Apr</P><P></P><P>Regards</P></BODY></HTML> Wed, 29 Apr 2015 06:05:45 GMT https://community.qlik.com/t5/QlikView/Need-help-on-update-Fiscal-year/m-p/845968#M297010 PrashantSangle 2015-04-29T06:05:45Z Re: Need help on update Fiscal year https://community.qlik.com/t5/QlikView/Need-help-on-update-Fiscal-year/m-p/845969#M297011 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Wed, 29 Apr 2015 06:35:40 GMT https://community.qlik.com/t5/QlikView/Need-help-on-update-Fiscal-year/m-p/845969#M297011 2015-04-29T06:35:40Z Re: Need help on update Fiscal year https://community.qlik.com/t5/QlikView/Need-help-on-update-Fiscal-year/m-p/845970#M297012 <HTML><HEAD></HEAD><BODY><P>Thank u. Let me cheak it once.</P><P></P><P></P><P>Regards,</P><P>Nagarjuna</P></BODY></HTML> Wed, 29 Apr 2015 06:50:37 GMT https://community.qlik.com/t5/QlikView/Need-help-on-update-Fiscal-year/m-p/845970#M297012 nagarjuna_kotha 2015-04-29T06:50:37Z Re: Need help on update Fiscal year https://community.qlik.com/t5/QlikView/Need-help-on-update-Fiscal-year/m-p/845971#M297013 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>What i want is ?</P><P>I have like this &gt;&gt;</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 148px;"><TBODY><TR><TD class="xl63" height="17" width="148">2012-2013</TD></TR><TR><TD class="xl63" height="17">2013-2014</TD></TR><TR><TD class="xl63" height="17"><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="161" style="width: 153px; height: 165px;" width="153"><TBODY><TR><TD class="xl63" height="17" width="148">2012-2013</TD></TR><TR><TD class="xl63" height="17">2013-2014</TD></TR><TR><TD class="xl63" height="17">2014-2015</TD></TR><TR><TD class="xl63" height="17">2015-2016</TD></TR><TR><TD class="xl63" height="17">2016-2017</TD></TR></TBODY></TABLE></TD></TR><TR><TD class="xl63" height="17">2016-2017</TD></TR></TBODY></TABLE><P></P><P>My requirement is </P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 148px;"><TBODY><TR><TD class="xl63" height="17" width="148"></TD></TR><TR><TD class="xl63" height="17">2014-2015</TD></TR><TR><TD class="xl63" height="17">2015-2016</TD></TR><TR><TD class="xl63" height="17"></TD></TR></TBODY></TABLE><P>I want above two only.How do i do ?</P><P></P><P></P><P></P><P>Regards,</P><P>Nagarjua</P></BODY></HTML> Wed, 29 Apr 2015 09:34:49 GMT https://community.qlik.com/t5/QlikView/Need-help-on-update-Fiscal-year/m-p/845971#M297013 nagarjuna_kotha 2015-04-29T09:34:49Z Re: Need help on update Fiscal year https://community.qlik.com/t5/QlikView/Need-help-on-update-Fiscal-year/m-p/845972#M297014 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Give condition in where clause.</P><P></P><P>Regards,</P></BODY></HTML> Wed, 29 Apr 2015 10:02:58 GMT https://community.qlik.com/t5/QlikView/Need-help-on-update-Fiscal-year/m-p/845972#M297014 PrashantSangle 2015-04-29T10:02:58Z Re: Need help on update Fiscal year https://community.qlik.com/t5/QlikView/Need-help-on-update-Fiscal-year/m-p/845973#M297015 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Thu, 30 Apr 2015 05:38:41 GMT https://community.qlik.com/t5/QlikView/Need-help-on-update-Fiscal-year/m-p/845973#M297015 2015-04-30T05:38:41Z