DATE How to convert the data to "November" and the Quarter

[#1]

DATE data has become a form of 2015/11/14.

From this data, or there is no way to be converted to a notation such as November? In the Excel functions and it can be in such as TEXT, but it could not be applied in QllikSense.

In addition, Quarter also I want to put together in such as Q1, Q2, but please tell me also to this method.

[jagan]

Hi,

Try like this

Data:

LOAD

*,

Date(Date#(DateFieldName, 'YYYY/MM/DD'))  AS Date,

Date(MonthEnd(Date#(DateFieldName, 'YYYY/MM/DD')), 'MMMM') AS Month,

'Q' & Ceil(Month(Date#(DateFieldName, 'YYYY/MM/DD'))/3) AS Quarter

FROM DataSource;

OR

The better way using Precedent load

Data:

Load *,

Date(MonthEnd(Date), 'MMMM') AS Month,

'Q' & Ceil(Month(Date)/3) AS Quarter

LOAD

*,

Date(Date#(DateFieldName, 'YYYY/MM/DD'))  AS Date

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

[jonathandienst]

For the month:

=Date(MonthStart(DATE), 'MMMM')

For the Quarter:

='Q' & Ceil(Month(DATE) / 3)

[#4]

Thanks for your reply.

However QlikSense responses from January, February,,,December and repeating from January, Februay,,,.

Regards,

Minoru Sakurai

[Anonymous]

Even simpler for the month:

month(DATE)

How to create a Calendar

[jagan]

HI,

I am not getting you, can you explain your requirement with some sample data and expected output.

Regards,

Jagan.

[#7]

Thanks for your support.

Attached screen-shot as below.

I'm writing to "Date(MonthStart([DEP DATE]), 'MMMM')".

[jagan]

Hi,

Try this

Date(MonthStart(Date#([DEP DATE], 'YYYYMMDD')), 'MMMM')

OR

Date(Floor(MonthStart(Date#([DEP DATE], 'YYYYMMDD'))), 'MMMM')

Regards,

Jagan.

[#9]

The both function didn't work well.

Now "Month" fields are nothing any word.

[jagan]

Hi,

What is your date format?  Where are you reading the data from?  What is the format you are getting in Qlikview?

Regards,

Jagan.