topic Re: Sort problem by listbox in QlikView

Sort problem by listbox

kris_vliegen — Fri, 01 Aug 2014 12:40:46 GMT

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

Re: Sort problem by listbox

Anonymous — Tue, 07 Oct 2014 08:56:02 GMT

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.

Re: Sort problem by listbox

tresB — Tue, 07 Oct 2014 09:06:07 GMT

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.

Re: Sort problem by listbox

kris_vliegen — Tue, 07 Oct 2014 09:41:04 GMT

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, ....)

Re: Sort problem by listbox

tresB — Tue, 07 Oct 2014 09:50:16 GMT

Try like:

Re: Sort problem by listbox

kris_vliegen — Tue, 07 Oct 2014 09:55:55 GMT

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