topic Re: Display Maximum or most Recent Years on the List Box Properties in QlikView https://community.qlik.com/t5/QlikView/Display-Maximum-or-most-Recent-Years-on-the-List-Box-Properties/m-p/808221#M285287 <HTML><HEAD></HEAD><BODY><P>Thank You Ruben .It works for me.:)</P></BODY></HTML> Tue, 03 Feb 2015 10:46:35 GMT Anonymous 2015-02-03T10:46:35Z Display Maximum or most Recent Years on the List Box Properties https://community.qlik.com/t5/QlikView/Display-Maximum-or-most-Recent-Years-on-the-List-Box-Properties/m-p/808219#M285285 <HTML><HEAD></HEAD><BODY><P>Good Morning..</P><P>I am facing one issue where i have list of Years&nbsp; from 2000 to 2015&nbsp; in List Box Properties and I wanted to display only maximum or recent 3 years on in List Box.Can anybody help me to resolve this issue.Thank You !</P></BODY></HTML> Mon, 02 Feb 2015 13:47:23 GMT https://community.qlik.com/t5/QlikView/Display-Maximum-or-most-Recent-Years-on-the-List-Box-Properties/m-p/808219#M285285 Anonymous 2015-02-02T13:47:23Z Re: Display Maximum or most Recent Years on the List Box Properties https://community.qlik.com/t5/QlikView/Display-Maximum-or-most-Recent-Years-on-the-List-Box-Properties/m-p/808220#M285286 <HTML><HEAD></HEAD><BODY><P>Hi Prasad, to show the recent 3 years in a list box you can use:</P><P>=Aggr(Only({1&lt;YearField={'&gt;$(=Year(Today())-3)'}&gt;} YearField), YearField)</P></BODY></HTML> Mon, 02 Feb 2015 14:19:52 GMT https://community.qlik.com/t5/QlikView/Display-Maximum-or-most-Recent-Years-on-the-List-Box-Properties/m-p/808220#M285286 rubenmarin 2015-02-02T14:19:52Z Re: Display Maximum or most Recent Years on the List Box Properties https://community.qlik.com/t5/QlikView/Display-Maximum-or-most-Recent-Years-on-the-List-Box-Properties/m-p/808221#M285287 <HTML><HEAD></HEAD><BODY><P>Thank You Ruben .It works for me.:)</P></BODY></HTML> Tue, 03 Feb 2015 10:46:35 GMT https://community.qlik.com/t5/QlikView/Display-Maximum-or-most-Recent-Years-on-the-List-Box-Properties/m-p/808221#M285287 Anonymous 2015-02-03T10:46:35Z