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: 
Not applicable

Month Number

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?

9 Replies
MK_QSL
MVP
MVP

Use calculated Dimension instead of Month Number

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

Not applicable
Author

I get error in  calculated dimension.

Not applicable
Author

can you upload your qvw?

simenkg
Specialist
Specialist

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

swuehl
MVP
MVP

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
Not applicable
Author

Simple,

Use Expression field.

AC

MK_QSL
MVP
MVP

Enclosed

Anonymous
Not applicable
Author

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]