Discussion board where members can get started with Qlik Sense.
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.
Try like this
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
The better way using Precedent load
Date(MonthEnd(Date), 'MMMM') AS Month,
'Q' & Ceil(Month(Date)/3) AS Quarter
Date(Date#(DateFieldName, 'YYYY/MM/DD')) AS Date
Hope this helps you.
For the month:
For the Quarter:
='Q' & Ceil(Month(DATE) / 3)
Thanks for your reply.
However QlikSense responses from January, February,,,December and repeating from January, Februay,,,.
Even simpler for the month:
How to create a Calendar
I am not getting you, can you explain your requirement with some sample data and expected output.
Thanks for your support.
Attached screen-shot as below.
I'm writing to "Date(MonthStart([DEP DATE]), 'MMMM')".
Date(MonthStart(Date#([DEP DATE], 'YYYYMMDD')), 'MMMM')
Date(Floor(MonthStart(Date#([DEP DATE], 'YYYYMMDD'))), 'MMMM')
The both function didn't work well.
Now "Month" fields are nothing any word.
What is your date format? Where are you reading the data from? What is the format you are getting in Qlikview?