Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Not applicable
Author

It is very simple "the date" datas by Excel as below;

 

2014/7/26
2014/7/26
2014/7/27
2014/7/27
2014/7/27

What I want to do is use to change from above date to "July, August,,,,Decmber".

sunilkumarqv
Specialist II
Specialist II

Example by default  your system variables

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

Change the above to

SET MonthNames='January;February;Marach;April;May;Jun;July;Augest;September;Octember;November;December';


in script


Load

Month(Date) as Month from datasource;


Not applicable
Author

Checked system and amend as per your suggestion however still don't change situation.