topic select last 3 years in default selection using trigger in QlikView https://community.qlik.com/t5/QlikView/select-last-3-years-in-default-selection-using-trigger/m-p/945330#M325639 <HTML><HEAD></HEAD><BODY><P>i On activate sheet select in field</P><P></P><P>Field</P><P>iyear</P><P></P><P>Search String</P><P>= year(Today())-2</P><P></P><P>This selects 2013 only</P><P></P><P>I want to select 2013, 2014 &amp; 2015 (the last 3 years including current)</P></BODY></HTML> Thu, 22 Oct 2015 14:03:11 GMT matthewp 2015-10-22T14:03:11Z select last 3 years in default selection using trigger https://community.qlik.com/t5/QlikView/select-last-3-years-in-default-selection-using-trigger/m-p/945330#M325639 <HTML><HEAD></HEAD><BODY><P>i On activate sheet select in field</P><P></P><P>Field</P><P>iyear</P><P></P><P>Search String</P><P>= year(Today())-2</P><P></P><P>This selects 2013 only</P><P></P><P>I want to select 2013, 2014 &amp; 2015 (the last 3 years including current)</P></BODY></HTML> Thu, 22 Oct 2015 14:03:11 GMT https://community.qlik.com/t5/QlikView/select-last-3-years-in-default-selection-using-trigger/m-p/945330#M325639 matthewp 2015-10-22T14:03:11Z Re: select last 3 years in default selection using trigger https://community.qlik.com/t5/QlikView/select-last-3-years-in-default-selection-using-trigger/m-p/945331#M325640 <HTML><HEAD></HEAD><BODY><P>try the synthase below</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">= '&gt;= ' &amp; $(=year(Today())-2)</SPAN></P></BODY></HTML> Thu, 22 Oct 2015 17:51:51 GMT https://community.qlik.com/t5/QlikView/select-last-3-years-in-default-selection-using-trigger/m-p/945331#M325640 2015-10-22T17:51:51Z