topic Re: Date Range in Text Box in QlikView https://community.qlik.com/t5/QlikView/Date-Range-in-Text-Box/m-p/1284791#M847404 <HTML><HEAD></HEAD><BODY><P>No sir,</P><P>It is missing first part. See below for year = 2015</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/157686_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Please help.</P><P></P><P>Thanks,</P><P>Sarif</P></BODY></HTML> Mon, 27 Mar 2017 10:43:10 GMT mhmmd_srf 2017-03-27T10:43:10Z Date Range in Text Box https://community.qlik.com/t5/QlikView/Date-Range-in-Text-Box/m-p/1284789#M847402 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>My requirement is if user select 2017 from Fiscal Year, then it should show October 2016 - September 2017.</P><P>Similarly if user select 2016, the October 2016 - September 2016.</P><P>My expression like below:</P><P></P><P><STRONG>='October ' &amp; 'GetFieldSelections(CstFiscalYear) -1' &amp; ' - ' &amp; 'September' &amp; 'GetFieldSelections(CstFiscalYear)'</STRONG></P><P></P><P>It is not working.</P><P>Could you please help me on this.</P><P></P><P>Thanks,</P><P>Sarif</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date-Range-in-Text-Box/m-p/1284789#M847402 mhmmd_srf 2020-11-25T16:16:04Z Re: Date Range in Text Box https://community.qlik.com/t5/QlikView/Date-Range-in-Text-Box/m-p/1284790#M847403 <HTML><HEAD></HEAD><BODY><P>try</P><P>='October ' &amp; GetFieldSelections(CstFiscalYear) -1 &amp; ' - ' &amp; 'September' &amp; GetFieldSelections(CstFiscalYear)</P></BODY></HTML> Mon, 27 Mar 2017 10:40:14 GMT https://community.qlik.com/t5/QlikView/Date-Range-in-Text-Box/m-p/1284790#M847403 annafuksa1 2017-03-27T10:40:14Z Re: Date Range in Text Box https://community.qlik.com/t5/QlikView/Date-Range-in-Text-Box/m-p/1284791#M847404 <HTML><HEAD></HEAD><BODY><P>No sir,</P><P>It is missing first part. See below for year = 2015</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/157686_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Please help.</P><P></P><P>Thanks,</P><P>Sarif</P></BODY></HTML> Mon, 27 Mar 2017 10:43:10 GMT https://community.qlik.com/t5/QlikView/Date-Range-in-Text-Box/m-p/1284791#M847404 mhmmd_srf 2017-03-27T10:43:10Z Re: Date Range in Text Box https://community.qlik.com/t5/QlikView/Date-Range-in-Text-Box/m-p/1284792#M847405 <HTML><HEAD></HEAD><BODY><P>and I will write is as</P><P></P><P>='October ' &amp; num(max(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">CstFiscalYear</SPAN>)-1)&nbsp; &amp; ' - ' &amp; 'September' &amp; max(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">CstFiscalYear</SPAN>)</P></BODY></HTML> Mon, 27 Mar 2017 10:43:30 GMT https://community.qlik.com/t5/QlikView/Date-Range-in-Text-Box/m-p/1284792#M847405 annafuksa1 2017-03-27T10:43:30Z Re: Date Range in Text Box https://community.qlik.com/t5/QlikView/Date-Range-in-Text-Box/m-p/1284793#M847406 <HTML><HEAD></HEAD><BODY><P>Just remove the single colon for Qlikview functionalities and then use from your expression</P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">='October ' &amp; GetFieldSelections(CstFiscalYear) -1 &amp; ' - ' &amp; 'September' &amp; GetFieldSelections(CstFiscalYear)</STRONG></P></BODY></HTML> Mon, 27 Mar 2017 10:54:36 GMT https://community.qlik.com/t5/QlikView/Date-Range-in-Text-Box/m-p/1284793#M847406 Anil_Babu_Samineni 2017-03-27T10:54:36Z