Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
For the month:
=Date(MonthStart(DATE), 'MMMM')
For the Quarter:
='Q' & Ceil(Month(DATE) / 3)
Thanks for your reply.
However QlikSense responses from January, February,,,December and repeating from January, Februay,,,.
Regards,
Minoru Sakurai
HI,
I am not getting you, can you explain your requirement with some sample data and expected output.
Regards,
Jagan.
Thanks for your support.
Attached screen-shot as below.
I'm writing to "Date(MonthStart([DEP DATE]), 'MMMM')".
Hi,
Try this
Date(MonthStart(Date#([DEP DATE], 'YYYYMMDD')), 'MMMM')
OR
Date(Floor(MonthStart(Date#([DEP DATE], 'YYYYMMDD'))), 'MMMM')
Regards,
Jagan.
The both function didn't work well.
Now "Month" fields are nothing any word.
Hi,
What is your date format? Where are you reading the data from? What is the format you are getting in Qlikview?
Regards,
Jagan.