Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gisellevaleta
New Contributor III

Month No to Month Name

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);

Tags (1)
4 Replies
narband2778
New Contributor III

Re: Month No to Month Name

Hi,

Try this

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


Thanks,

Naresh

gisellevaleta
New Contributor III

Re: Month No to Month Name

Thanks works perfectly.

agigliotti
Honored Contributor II

Re: Month No to Month Name

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
Valued Contributor II

Re: Month No to Month Name

hi Valeta,

Both should do the work:

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

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

G.

Community Browser