Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Date format issue

I am getting raw data from an Oracle view. The view return data in MM/DD/YYYY format but when I show up this filed (ORIGINATED_MONTH) in QV graphs is shows up as mm/dd/yyyy hh:mm:ss AM. Where hh:mm:ss AM is always 12:00:00 AM.

ORIGINATED_MONTH is my dimension in the graph.

The date format is taking up space in the x-axis of the graphs, kindly suggest a setting to remove it.

I have below mentioned setting in the load script:

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

ODBC CONNECT TO [MX2RDBMS-READONLY];

SQL SELECT "EMP_DEPT_NAME",
"EMP_GEO",
NTID
FROM MX2RDBMS.USER_DATA_FOR_QV;

SQL SELECT DIVISION,
PROJECT
FROM MX2RDBMS.PROJDIVMAP;

SQL SELECT NAME,
NTID,
"ORIGINATED_DAY",
"ORIGINATED_MONTH",
PROJECT,
STATE,
YEAR,
MONTH,
QUARTER,
WEEK
FROM MX2RDBMS."ECO_FOR_QV";



Tags (1)
1 Reply

Date format issue

In Document Properties, Number tab, change the format of ORGINATED_MONTH to be Date with the formatting you want.

-Rob