topic Re: Button for Current Quarter/Year in QlikView https://community.qlik.com/t5/QlikView/Button-for-Current-Quarter-Year/m-p/1245291#M860147 <HTML><HEAD></HEAD><BODY><P>Perfect. Thanks </P></BODY></HTML> Fri, 13 Jan 2017 16:14:40 GMT jeckstein 2017-01-13T16:14:40Z Button for Current Quarter/Year https://community.qlik.com/t5/QlikView/Button-for-Current-Quarter-Year/m-p/1245288#M860144 <HTML><HEAD></HEAD><BODY><P>I have a filed called Quarter Year and I need to create a button using the action toggle select. I need the button to select the current quarter-year. </P><P></P><P>The field I am selecting from is called "QuarterYear" and is formatted like</P><P></P><P>Q1-16</P><P>Q2-16</P><P>Q3-16</P><P>Q4-16</P><P>Q1-17</P><P></P><P>Since today is 01-13-2017 the button should toggle select Q1-17.</P><P></P><P>thanks in advance</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Button-for-Current-Quarter-Year/m-p/1245288#M860144 jeckstein 2020-11-25T16:16:04Z Re: Button for Current Quarter/Year https://community.qlik.com/t5/QlikView/Button-for-Current-Quarter-Year/m-p/1245289#M860145 <HTML><HEAD></HEAD><BODY><P>Like this?</P></BODY></HTML> Fri, 13 Jan 2017 15:56:41 GMT https://community.qlik.com/t5/QlikView/Button-for-Current-Quarter-Year/m-p/1245289#M860145 MK_QSL 2017-01-13T15:56:41Z Re: Button for Current Quarter/Year https://community.qlik.com/t5/QlikView/Button-for-Current-Quarter-Year/m-p/1245290#M860146 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P>Field</P><P><STRONG>QuarterYear</STRONG></P><P></P><P>SearchString</P><P><STRONG>'Q' &amp; Ceil(Month(Today())/3) &amp; '-' &amp; Date(Today(), 'YY')</STRONG></P></BODY></HTML> Fri, 13 Jan 2017 15:56:52 GMT https://community.qlik.com/t5/QlikView/Button-for-Current-Quarter-Year/m-p/1245290#M860146 sunny_talwar 2017-01-13T15:56:52Z Re: Button for Current Quarter/Year https://community.qlik.com/t5/QlikView/Button-for-Current-Quarter-Year/m-p/1245291#M860147 <HTML><HEAD></HEAD><BODY><P>Perfect. Thanks </P></BODY></HTML> Fri, 13 Jan 2017 16:14:40 GMT https://community.qlik.com/t5/QlikView/Button-for-Current-Quarter-Year/m-p/1245291#M860147 jeckstein 2017-01-13T16:14:40Z