Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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

Re: Month Number

Use calculated Dimension instead of Month Number

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

Not applicable

Re: Month Number

I get error in  calculated dimension.

Not applicable

Re: Month Number

can you upload your qvw?

bwisenosimenkg
Valued Contributor

Re: Month Number

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

MVP
MVP

Re: Month Number

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

Hi,

best answer so far.

Also possible:

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

hope this helps

regards

Marco

bestofwest
Contributor II

Re: Month Number

Simple,

Use Expression field.

AC

Re: Re: Month Number

Enclosed

asimansari2017
New Contributor III

Re: Month Number

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]

Community Browser