topic Re: Month as Text not Month Number in QlikView

Month as Text not Month Number

Wed, 19 Sep 2012 14:04:21 GMT

In one instance I am using a field

Month(InvoiceDate) as [Weekly Month],

This returns a month number rather than the name. Is there a way to also map this to a name? To display Jan,Feb,Mar etc.

Re: Month as Text not Month Number

MayilVahanan — Wed, 19 Sep 2012 14:11:16 GMT

Month(InvoiceDate) return number? But it display jan,feb...

Any way, try like this,

Load * inline

[

Month,WeeklyMonth

jan,1

feb,2

Dec,12

];

And use Month as field for your requirement

Hope it helps

Re: Month as Text not Month Number

swuehl — Wed, 19 Sep 2012 14:39:43 GMT

Month() should return a dual value (check out the Help for more details on Month and dual value).

So it carries as well a numeric as a text value. You can force QV to return either one by using

num(Month(DATEFIELD))

text(Month(DATEFIELD))

If you don't force QV, it will return the value depending on the context, i.e. if comparing to a numeric value, it will return the numeric representation. If you use Month(DATEFIELD) as dimension, it will probably use the text value.

Where do you use your dual (i.e. [Weekly Month] field)?

Hope this helps,

Stefan

Re: Month as Text not Month Number

Wed, 19 Sep 2012 14:59:32 GMT

The reason for two month selections is that an invoice has two month options, one for the invoice date, the second is what year and period the invoice is added to the General Ledger.

The date selection at the top uses the GL dates, and the forecast year uses the invoice date (Weekly Month)

@Swuehl when forcing the text as month it only displays Jan and Dec, with the majority of data being held under Jan.

Re: Month as Text not Month Number

swuehl — Wed, 19 Sep 2012 15:05:23 GMT

I can't see your complete calculated dimension you are using, but check that you are not applying month() function to a field that hold month values already.

Re: Month as Text not Month Number

CELAMBARASAN — Wed, 19 Sep 2012 20:52:17 GMT

Are you applying Month function to the month number(may be a month field)?

If so try with Text(MonthFieldName)