Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
kris_vliegen
Partner - Creator III
Partner - Creator III

Sort problem by listbox

Hi all,

I have a problem sorting values in a listbox.

I've tried to make my Monthnames multilangual.

Now I would like to have that the months are not sorted alfabetical but numeric.

And the months may not change from position after selection of 1 month.

In my testdashboard you can see that the monthname created by the month-function is sorting good.

But that the translated monthnames are not sorting like I would like to see.

Regards,

Kris

5 Replies
Anonymous
Not applicable

Hallo Kris,

nimm in deinen Listboxen erst einmal alle Haken raus und trage als Bedingung für die Sortierung

nur "CalMonthNum" als Formel ein. Dies sollte dann funktionieren.

tresesco
MVP
MVP

For CallMonthEN field, use the same sort prefence as you have done in CallMonthNum field, i.e: State: 'Auto Ascending', Numeric Value: 'Ascending' .  Untick all the rest.

kris_vliegen
Partner - Creator III
Partner - Creator III
Author

Hello guys,

I've tried both your solutions. But as you can see it isn't working.

I would like to see the listbox 'CalMonthEn' in order of the monthnumbers. (Jan, Feb, Mar, ....)

listbox1.JPG.jpglistbox2.JPG.jpg

tresesco
MVP
MVP

Try like:

Screen Shot 10-07-14 at 03.19 PM.PNG.png

kris_vliegen
Partner - Creator III
Partner - Creator III
Author

Are you using my demo-dashboard? Because I don't get the same result like you have.

listbox3.JPG.jpg