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.
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".
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;
Checked system and amend as per your suggestion however still don't change situation.