Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

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
gkiessling
New Contributor

Re: Sort problem by listbox

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.

MVP
MVP

Re: Sort problem by listbox

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.

Partner
Partner

Re: Sort problem by listbox

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

MVP
MVP

Re: Sort problem by listbox

Try like:

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

Partner
Partner

Re: Sort problem by listbox

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

listbox3.JPG.jpg