Month Number

[#1]

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?

[MK_QSL]

Use calculated Dimension instead of Month Number

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

[#3]

I get error in  calculated dimension.

[#4]

can you upload your qvw?

[simenkg]

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

[swuehl]

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.

[MarcoWedel]

Hi,

best answer so far.

Also possible:

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

hope this helps

regards

Marco

[Anonymous]

Simple,

Use Expression field.

AC

[MK_QSL]

Enclosed

[Anonymous]

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]