Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

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

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

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

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

Community Browser