Month No to Month Name

[gisellevaleta]

Hi Everyone,

Please can you assist, I need to change the field "MT NO" in below to return the Month Name and not the Month No.

LOAD

    "YR SEASON CODE" as "Year Season Code",

    "MT NO" as "Month",

    "WK NO" as "Week No",

    "YR NO" as "Year"

FROM [lib://QlikData.qvd]

(qvd);

[narband2778]

Hi,

Try this

=month(MakeDate(2000,'MT NO'))

Thanks,

Naresh

[gisellevaleta]

Thanks works perfectly.

[agigliotti]

Let's try as below:

LOAD *,

     Month( MakeDate(Year, Month, 1) ) as New_Month;

LOAD

    "YR SEASON CODE" as "Year Season Code",

    "MT NO" as "Month",

    "WK NO" as "Week No",

    "YR NO" as "Year"

FROM [lib://QlikData.qvd]

(qvd);

in the UI you can use New_Month as dimension.

[undergrinder]

hi Valeta,

Both should do the work:

=month(makedate(2018,'MT NO',1))

=date(makedate(2018,'MT NO',1),'MMM')

G.