Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Change Month Dimension Sort Order not working correctly

Hi everyone,

So I came across a question on the community, and I found the following:

=match([Month],'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

using this expression, I can change the sort order for months. this works fine within a normal listbox,

but when I do the same in a multibox (when adding Month as an expression) it gives me back the numerical value for each one,

as in 1,2,3,4,5,6,7,8,9,10,11,12

How can I change this expression to give me the actual month name, instead of the numerical values?

Thanks!

1 Solution

Accepted Solutions
qlikoqlik
Creator
Creator

Did you try to add the above expression in the sort tab of the properties

View solution in original post

4 Replies
rubenmarin

Hi Stefan, I didn't tested but maybe?:

Dual([Month], match([Month],'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'))

If in script you create the month with the Month() funtion it will automatically save Month as a Dual value (a number with a text representation) wich can be sorted easily as it is actually a number.

qlikoqlik
Creator
Creator

Did you try to add the above expression in the sort tab of the properties

arulsettu
Master III
Master III

use this in script

=month(MakeDate(2000,numericMonthField))

It doesn't matter what year you use in the Makedate() function.

Anonymous
Not applicable
Author

so ridiculous of me!

Yes, I just used the same expression under the Sort tab for the Multibox, and it works just fine

Thank you!