topic Re: Month Number in QlikView

Month Number

Mon, 26 Jan 2026 18:19:17 GMT

I have graphic with Month number on X-as.

I sort on Month number, but want to present Month Name.

How can i do this?

Re: Month Number

MK_QSL — Wed, 03 Dec 2014 22:46:54 GMT

Use calculated Dimension instead of Month Number

Dual([Month Number],Subfield('$(MonthNames)',';',[Month Number])

Re: Month Number

Wed, 03 Dec 2014 22:57:57 GMT

I get error in calculated dimension.

Re: Month Number

Wed, 03 Dec 2014 23:18:19 GMT

can you upload your qvw?

Re: Month Number

simenkg — Wed, 03 Dec 2014 23:23:11 GMT

Use month name as dimension and under the sort tab; select "Expression" and input month number.

Re: Month Number

swuehl — Wed, 03 Dec 2014 23:26:50 GMT

Try as dimension

=Month(Makedate(2014,[Month Number]) )

Month function automatically returns the month name as text and (because it's a dual value) keeps the Month Number for sorting numerically.

edit: And it would be even better to create a field in the load script like this to get Month dual values with text and number from your [Month Number] field.

Re: Re: Month Number

MarcoWedel — Thu, 04 Dec 2014 00:14:42 GMT

Hi,

best answer so far.

Also possible:

=Month(Date#(monthnum,'MM'))

hope this helps

regards

Marco

Re: Month Number

Anonymous — Thu, 04 Dec 2014 00:24:43 GMT

Simple,

Use Expression field.

Re: Re: Month Number

MK_QSL — Thu, 04 Dec 2014 07:28:04 GMT

Enclosed

Re: Month Number

Anonymous — Thu, 04 Dec 2014 07:39:31 GMT

Simple load inline with

No Month

1 Jan

2 Feb

3 Mar

4 Apr

5 May

6 Jun

7 Jul

8 Aug

9 Sep

10 Oct

11 Nov

12 Dec

And sort with Expression sort

Inline[No]