Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Convert number to month - 1 field

Hi,

Can someone provide answer to how I can convert number on the LatestBidMonth field on the attached to actual month text (e.g January).

1 needs to be January, 2 February etc.

Chris

1 Solution

Accepted Solutions

Re: Convert number to month - 1 field

Check this out

Capture.PNG

Script:

Table:

LOAD Band,

    NumberBids,

    LatestBidYear,

    LatestBidMonth as Temp_LatestBidMonth,

    Month(Date#(LatestBidMonth, 'M')) as LatestBidMonth

FROM

calenderqv.xlsx

(ooxml, embedded labels, table is Sheet1);

View solution in original post

7 Replies

Re: Convert number to month - 1 field

You can try like this:

Month(Date#(LatestBidMonth, 'M')) as LatestBidMonth

migueldelval
Valued Contributor

Re: Convert number to month - 1 field

Hi Chris,

Could you explain a little bit your question?

Regards

Miguel del Valle

Not applicable

Re: Convert number to month - 1 field

Hi Sunny,

Ok and where does this go? In the script or within properties of table box?

Chris

Re: Convert number to month - 1 field

Check this out

Capture.PNG

Script:

Table:

LOAD Band,

    NumberBids,

    LatestBidYear,

    LatestBidMonth as Temp_LatestBidMonth,

    Month(Date#(LatestBidMonth, 'M')) as LatestBidMonth

FROM

calenderqv.xlsx

(ooxml, embedded labels, table is Sheet1);

View solution in original post

Re: Convert number to month - 1 field

Script... Provided the script below for the sample your have provided

Not applicable

Re: Convert number to month - 1 field

Want to able to assess bids but not easy to do when numbers. With actual text can easily see bids per month.

Chris

antoniotiman
Honored Contributor III

Re: Convert number to month - 1 field

Try

Date(Date#(LatestBidMonth,'MM'),'MMMM')  as Month