topic How to Select the next 4 months in QlikView https://community.qlik.com/t5/QlikView/How-to-Select-the-next-4-months/m-p/601390#M1112308 <HTML><HEAD></HEAD><BODY><P>On opening a sheet i would like to force Feb, Mar,Apr,May to trigger for 2014.</P><P>I can trigger a variable for VCurrentYear and vCurrentMonth.</P><P>How do i expand this to be the next 4 inclusive.?</P><P>thanks</P></BODY></HTML> Tue, 18 Feb 2014 15:49:56 GMT timsaddler 2014-02-18T15:49:56Z How to Select the next 4 months https://community.qlik.com/t5/QlikView/How-to-Select-the-next-4-months/m-p/601390#M1112308 <HTML><HEAD></HEAD><BODY><P>On opening a sheet i would like to force Feb, Mar,Apr,May to trigger for 2014.</P><P>I can trigger a variable for VCurrentYear and vCurrentMonth.</P><P>How do i expand this to be the next 4 inclusive.?</P><P>thanks</P></BODY></HTML> Tue, 18 Feb 2014 15:49:56 GMT https://community.qlik.com/t5/QlikView/How-to-Select-the-next-4-months/m-p/601390#M1112308 timsaddler 2014-02-18T15:49:56Z Re: How to Select the next 4 months https://community.qlik.com/t5/QlikView/How-to-Select-the-next-4-months/m-p/601391#M1112309 <HTML><HEAD></HEAD><BODY><P>Hi Tim,</P><P></P><P>use a formula, like</P><P>&gt;&gt;&gt; ([month_field] &gt;= v_current_month AND [month_field] &lt;= (v_current_month + 3)) &lt;&lt;&lt;</P></BODY></HTML> Tue, 18 Feb 2014 15:52:56 GMT https://community.qlik.com/t5/QlikView/How-to-Select-the-next-4-months/m-p/601391#M1112309 datanibbler 2014-02-18T15:52:56Z Re: How to Select the next 4 months https://community.qlik.com/t5/QlikView/How-to-Select-the-next-4-months/m-p/601392#M1112310 <HTML><HEAD></HEAD><BODY><P>set vCurrentMonth = <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">("Feb"|"Mar"|"Apr"|"May")</SPAN></P></BODY></HTML> Tue, 18 Feb 2014 15:57:18 GMT https://community.qlik.com/t5/QlikView/How-to-Select-the-next-4-months/m-p/601392#M1112310 manojkulkarni 2014-02-18T15:57:18Z Re: How to Select the next 4 months https://community.qlik.com/t5/QlikView/How-to-Select-the-next-4-months/m-p/601393#M1112311 <HTML><HEAD></HEAD><BODY><P>Use select in field on your date field and use this as the search string:</P><P></P><P>='&gt;=' &amp; MonthStart(Today()) &amp; '&lt;=' &amp; MonthEnd(AddMonths(Today(), 3))</P><P></P><P>In document properties on the triggers tab you can add this as a on open trigger.</P></BODY></HTML> Tue, 18 Feb 2014 16:01:43 GMT https://community.qlik.com/t5/QlikView/How-to-Select-the-next-4-months/m-p/601393#M1112311 jpapador 2014-02-18T16:01:43Z