Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Customizing display of listbox values

Hello, is it possible to customize a listbox to display 3 latest months inside a "normal" listbox

an example where oct-2013 the current month.

Oct-2013

Sep-2013

Aug-2013

--------------

Jan-2012

Feb-2012

Mar-2012
...

aug-2013

sep-2013

oct-2013

3 Replies
tresesco
MVP
MVP

Use list box expression like: =Aggr(If(rank(MonthName)<4,MonthName),MonthName)

PFA

Not applicable
Author

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:)

Sorting Months.png

tresesco
MVP
MVP

Sort on expression =If(Rank(MonthName)>3,Rank(MonthName)-10,Rank(MonthName))

PFA