Discussion Board for collaboration related to QlikView App Development.
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.
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.
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.
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, ....)
Are you using my demo-dashboard? Because I don't get the same result like you have.