topic Re: last 3 year in list box in QlikView https://community.qlik.com/t5/QlikView/last-3-year-in-list-box/m-p/1006578#M341854 <HTML><HEAD></HEAD><BODY><P>Tyr like:</P><P></P><P>=Aggr(If(Rank(SubField(Year,'-',1))&lt;=3, Year),Year)</P><P></P><P>PFA</P></BODY></HTML> Tue, 06 Oct 2015 12:51:57 GMT tresB 2015-10-06T12:51:57Z last 3 year in list box https://community.qlik.com/t5/QlikView/last-3-year-in-list-box/m-p/1006577#M341853 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I want to show only last three years in list box.</P><P></P><P>e.g.</P><P>2015-2016</P><P>2014-2015</P><P>2013-2014</P><P></P><P>Thanks</P></BODY></HTML> Tue, 06 Oct 2015 12:47:02 GMT https://community.qlik.com/t5/QlikView/last-3-year-in-list-box/m-p/1006577#M341853 prma7799 2015-10-06T12:47:02Z Re: last 3 year in list box https://community.qlik.com/t5/QlikView/last-3-year-in-list-box/m-p/1006578#M341854 <HTML><HEAD></HEAD><BODY><P>Tyr like:</P><P></P><P>=Aggr(If(Rank(SubField(Year,'-',1))&lt;=3, Year),Year)</P><P></P><P>PFA</P></BODY></HTML> Tue, 06 Oct 2015 12:51:57 GMT https://community.qlik.com/t5/QlikView/last-3-year-in-list-box/m-p/1006578#M341854 tresB 2015-10-06T12:51:57Z