topic Re: num month in name month in QlikView

num month in name month

Mon, 23 Feb 2015 09:36:49 GMT

Hi all,

I have a problem. I have in my script a field Month which has number's months (1,2,3,4,5,6,...,12).

I don't have a date field and I want to convert the number's months in text (Jan, Feb, Mar,Apr, Jul,..., Dic).

How can I make it?

Please, it's important.

Thanks.

Re: num month in name month

PrashantSangle — Mon, 23 Feb 2015 09:40:38 GMT

Hi,

Use Inline table

try like

load * INLINE[

Month,MonthName

1,Jan

2,Feb

...

];

Regards

Re: num month in name month

tresB — Mon, 23 Feb 2015 09:42:46 GMT

Month(MakeDate(0,MonthNum)) as Month

Re: num month in name month

MK_QSL — Mon, 23 Feb 2015 10:03:16 GMT

SubField('$(MonthNames)',';',MonthNumberField) as MonthNameField

Re: num month in name month

prieper — Mon, 23 Feb 2015 10:10:10 GMT

Recommend to always convert partial dates into real dates and then to use QV's built-in logic and functions to handle in a formatted way.

So you may create a field with eg

MAKEDATE(1, MonthNum, Year) AS Date

HTH Peter

Re: num month in name month

Gabriel — Mon, 23 Feb 2015 14:55:42 GMT

Hi,

Try this

DateNum:

LOAD * Inline

[

DaNUM

];

FOR i =0 to NoOfRows('DateNum') - 1

LET vMonthName =Peek('DaNUM',$(i),'DateNum');

Final:

LOAD

'$(vMonthName)' AS Month_Num

,MonthName(MakeDate(Date(Year(TODAY()),'YYYY'),$(vMonthName))) AS MonthName

Resident DateNum;

NEXT i

DROP Table DateNum;

Re: num month in name month

Mon, 23 Feb 2015 16:37:36 GMT

Thanks a lot! It's what I wanted. In this way I have no problem to order the new field MonthName.