topic Re: Re: Customizing display of listbox values in QlikView https://community.qlik.com/t5/QlikView/Customizing-display-of-listbox-values/m-p/535692#M200173 <HTML><HEAD></HEAD><BODY><P>Sort on expression =If(Rank(MonthName)&gt;3,Rank(MonthName)-10,Rank(MonthName))</P><P></P><P>PFA</P></BODY></HTML> Mon, 20 Jan 2014 13:23:12 GMT tresB 2014-01-20T13:23:12Z Customizing display of listbox values https://community.qlik.com/t5/QlikView/Customizing-display-of-listbox-values/m-p/535689#M200170 <HTML><HEAD></HEAD><BODY><P>Hello, is it possible to customize a listbox to display 3 latest months inside a "normal" listbox</P><P></P><P>an example where oct-2013 the current month.</P><P></P><P>Oct-2013</P><P>Sep-2013</P><P>Aug-2013</P><P>--------------</P><P>Jan-2012</P><P>Feb-2012</P><P>Mar-2012<BR />...</P><P>aug-2013</P><P>sep-2013</P><P>oct-2013</P></BODY></HTML> Mon, 20 Jan 2014 11:36:53 GMT https://community.qlik.com/t5/QlikView/Customizing-display-of-listbox-values/m-p/535689#M200170 2014-01-20T11:36:53Z Re: Customizing display of listbox values https://community.qlik.com/t5/QlikView/Customizing-display-of-listbox-values/m-p/535690#M200171 <HTML><HEAD></HEAD><BODY><P>Use list box expression like: =Aggr(If(rank(MonthName)&lt;4,MonthName),MonthName)</P><P></P><P>PFA</P></BODY></HTML> Mon, 20 Jan 2014 12:19:36 GMT https://community.qlik.com/t5/QlikView/Customizing-display-of-listbox-values/m-p/535690#M200171 tresB 2014-01-20T12:19:36Z Re: Customizing display of listbox values https://community.qlik.com/t5/QlikView/Customizing-display-of-listbox-values/m-p/535691#M200172 <HTML><HEAD></HEAD><BODY><P>thank you for your reply. And I can see that my question was not well described, sorry about that. But I would like to know is. After AUG can I then show the remaning months. Created a photo from your example that might show a little better how I whish i could get it. Imagine that this is one listbox and not one ontop of another:)</P><P><IMG alt="Sorting Months.png" class="jive-image" src="/legacyfs/online/51755_Sorting Months.png" /></P></BODY></HTML> Mon, 20 Jan 2014 13:06:19 GMT https://community.qlik.com/t5/QlikView/Customizing-display-of-listbox-values/m-p/535691#M200172 2014-01-20T13:06:19Z Re: Re: Customizing display of listbox values https://community.qlik.com/t5/QlikView/Customizing-display-of-listbox-values/m-p/535692#M200173 <HTML><HEAD></HEAD><BODY><P>Sort on expression =If(Rank(MonthName)&gt;3,Rank(MonthName)-10,Rank(MonthName))</P><P></P><P>PFA</P></BODY></HTML> Mon, 20 Jan 2014 13:23:12 GMT https://community.qlik.com/t5/QlikView/Customizing-display-of-listbox-values/m-p/535692#M200173 tresB 2014-01-20T13:23:12Z