Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

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.

12 Replies
MVP
MVP

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

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.

MVP
MVP

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

For the month:

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

For the Quarter:

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

Not applicable

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

Thanks for your reply.

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

Regards,

Minoru Sakurai

mov
Esteemed Contributor III

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

Even simpler for the month:

month(DATE)

How to create a Calendar

MVP
MVP

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

HI,

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

Regards,

Jagan.

Not applicable

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

Thanks for your support.

Attached screen-shot as below.

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

MVP
MVP

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

Hi,

Try this

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


OR


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


Regards,

Jagan.

Not applicable

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

The both function didn't work well.

Now "Month" fields are nothing any word.

MVP
MVP

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

Hi,

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

Regards,

Jagan.

Community Browser