topic Re: Reduce values in listbox in QlikView https://community.qlik.com/t5/QlikView/Reduce-values-in-listbox/m-p/1249751#M395704 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Wed, 08 Mar 2017 09:59:39 GMT nigel987 2017-03-08T09:59:39Z Reduce values in listbox https://community.qlik.com/t5/QlikView/Reduce-values-in-listbox/m-p/1249749#M395702 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a listbox with Year values: 2010 - 2017</P><P>I just want to show the values for the last 24 months. Therfore I use: </P><P>=Aggr(Only({&lt;Jahr={"=Jahr&gt;= $(=Year(MonthStart(AddMonths(Max(Today()),-24))))"}&gt;}Jahr),Jahr)</P><P>This works as expected. I now see only the values 2015-2017</P><P></P><P>But when I select a Year value, let's say 2016, only 2016 is displayed in the listbox. Is there a way to show 2015-2017 values and only highlight the selected one green (like the standard behaviour)?</P><P></P><P>Thanks!</P><P>Nihal</P></BODY></HTML> Wed, 08 Mar 2017 09:25:07 GMT https://community.qlik.com/t5/QlikView/Reduce-values-in-listbox/m-p/1249749#M395702 nigel987 2017-03-08T09:25:07Z Re: Reduce values in listbox https://community.qlik.com/t5/QlikView/Reduce-values-in-listbox/m-p/1249750#M395703 <HTML><HEAD></HEAD><BODY><P>try using IF rather than aggr() like:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG><EM>If (</EM></STRONG><EM> Jahr&gt;= $(=Year(MonthStart(AddMonths(Max(Today()),-24)))) , <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Jahr</STRONG></SPAN></EM><STRONG><EM>)</EM></STRONG></SPAN></P></BODY></HTML> Wed, 08 Mar 2017 09:28:42 GMT https://community.qlik.com/t5/QlikView/Reduce-values-in-listbox/m-p/1249750#M395703 tresB 2017-03-08T09:28:42Z Re: Reduce values in listbox https://community.qlik.com/t5/QlikView/Reduce-values-in-listbox/m-p/1249751#M395704 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Wed, 08 Mar 2017 09:59:39 GMT https://community.qlik.com/t5/QlikView/Reduce-values-in-listbox/m-p/1249751#M395704 nigel987 2017-03-08T09:59:39Z