Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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