topic Re: filter on selection list box in QlikView https://community.qlik.com/t5/QlikView/filter-on-selection-list-box/m-p/562881#M1143803 <HTML><HEAD></HEAD><BODY><P>HI, use this in list box IF(Year &gt; 2011,Year) -Sathish</P></BODY></HTML> Wed, 07 Aug 2013 08:21:22 GMT sathishkumar_go 2013-08-07T08:21:22Z filter on selection list box https://community.qlik.com/t5/QlikView/filter-on-selection-list-box/m-p/562879#M1143801 <HTML><HEAD></HEAD><BODY><P>I have an QV-application with several sheets.</P><P>The history in the data is from the last 5 years. Now I want to privide to use only the data of the last 2 year on 2 sheets in the year selection list box.</P><P>Now users can choose in 2008, 2009, 2010, 2011, 2012, 2013.</P><P>I assume it's simple but how to privide that they can only choose in 2012, 2013</P></BODY></HTML> Wed, 07 Aug 2013 08:16:04 GMT https://community.qlik.com/t5/QlikView/filter-on-selection-list-box/m-p/562879#M1143801 2013-08-07T08:16:04Z Re: filter on selection list box https://community.qlik.com/t5/QlikView/filter-on-selection-list-box/m-p/562880#M1143802 <HTML><HEAD></HEAD><BODY><P>take a list box, in the general tab, select &lt;Expression&gt; instead of the year field, write this:</P><P></P><P>=If(YourYearField=2012 or YourYearField=2013,YourYearField)</P><P></P><P>in the expression.</P></BODY></HTML> Wed, 07 Aug 2013 08:21:04 GMT https://community.qlik.com/t5/QlikView/filter-on-selection-list-box/m-p/562880#M1143802 tresB 2013-08-07T08:21:04Z Re: filter on selection list box https://community.qlik.com/t5/QlikView/filter-on-selection-list-box/m-p/562881#M1143803 <HTML><HEAD></HEAD><BODY><P>HI, use this in list box IF(Year &gt; 2011,Year) -Sathish</P></BODY></HTML> Wed, 07 Aug 2013 08:21:22 GMT https://community.qlik.com/t5/QlikView/filter-on-selection-list-box/m-p/562881#M1143803 sathishkumar_go 2013-08-07T08:21:22Z