Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

list box sort problem (after click for the remaining grey out content)

Hi Friends,

i have sort problem with a list box. so we have a field name like FY16-FEB format. to sort it based on our fiscal month, i created a MonthSort field corresponding with it. so i will show the Period listbox which is sorted by MonthSort. if nothing be click, it looks fine:

Capture1.PNG

you can see the Aug is our first month and it will have Monthsort value 1601. but once i click, things get crazy

Capture2 wrong.PNG

the grey area, the MonthSort behave as wanted, but the PERIOD is totally messed up, and i have no idea what kind of sort the grey items are using!

since i am showing PERIOD, customer is very confused if they want to choose another month.

can anybody help. i tried every possible setting i can use on the sort tab in the listbox... currently is:

Capture sort set.PNG

2 Replies
Not applicable
Author

oh i use set analysis fix it myself. never mind!!! thanks

avinashelite

Un-check the Sort by state option and try that will give you the desired results