
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- « Previous Replies
-
- 1
- 2
- Next Replies »

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For the month:
=Date(MonthStart(DATE), 'MMMM')
For the Quarter:
='Q' & Ceil(Month(DATE) / 3)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for your reply.
However QlikSense responses from January, February,,,December and repeating from January, Februay,,,.
Regards,
Minoru Sakurai

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI,
I am not getting you, can you explain your requirement with some sample data and expected output.
Regards,
Jagan.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for your support.
Attached screen-shot as below.
I'm writing to "Date(MonthStart([DEP DATE]), 'MMMM')".

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Try this
Date(MonthStart(Date#([DEP DATE], 'YYYYMMDD')), 'MMMM')
OR
Date(Floor(MonthStart(Date#([DEP DATE], 'YYYYMMDD'))), 'MMMM')
Regards,
Jagan.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The both function didn't work well.
Now "Month" fields are nothing any word.

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
What is your date format? Where are you reading the data from? What is the format you are getting in Qlikview?
Regards,
Jagan.

- « Previous Replies
-
- 1
- 2
- Next Replies »