topic Re: Change Month Dimension Sort Order not working correctly in QlikView

Change Month Dimension Sort Order not working correctly

Anonymous — Fri, 30 Jan 2015 10:53:44 GMT

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!

Re: Change Month Dimension Sort Order not working correctly

rubenmarin — Fri, 30 Jan 2015 11:02:40 GMT

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.

Re: Change Month Dimension Sort Order not working correctly

qlikoqlik — Fri, 30 Jan 2015 11:18:33 GMT

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

Re: Change Month Dimension Sort Order not working correctly

arulsettu — Fri, 30 Jan 2015 11:21:54 GMT

use this in script

=month(MakeDate(2000,numericMonthField))

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

Re: Change Month Dimension Sort Order not working correctly

Anonymous — Fri, 30 Jan 2015 11:28:15 GMT

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!