Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gisellevaleta
Contributor III
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);

4 Replies
narband2778
Creator II
Creator II

Hi,

Try this

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


Thanks,

Naresh

gisellevaleta
Contributor III
Contributor III

Thanks works perfectly.

agigliotti
Partner
Partner

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
Specialist II
Specialist II

hi Valeta,

Both should do the work:

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

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

G.