month

[NavinReddy]

Dear all,

Month

01

02

How can i make this in to

Month

jan

Feb

some one guide me

Regards,

Niranjan

[alex_millan]

monthname('Date')

[nagaiank]

You may use Dual function.

For further details, see the Qlikview Reference Manual.

[alexandros17]

Subfield(MonthNames,';',Month)

Where Month is your month in format 01 ..12 and

monthnames is the variable defined in main ....

[jerem1234 · Accepted solution]

You can try:

month(date#(Month, 'MM'))

Hope this helps!

[MK_QSL]

SubField('$(MonthNames)', ';' , Month) as MonthName