Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Specialist
Specialist

Date shows as 1900

This date field works fine everywhere else but in this new chart, it shows as 1900. I added date#() in the script but it didn't fix it.

Script:

date("ADJ_GOVERNANCE_PHASE_START_DATE", 'MM/DD/YYYY') as ADJ_GOVERNANCE_PHASE_START_DATE,

Dashboard displays all as 1900

2020-10-19_13-08-20.jpg

Chart Dimensions: (ADJ_GOVERNANCE_PHASE_START_DATE)

Chart expression: if(isnull(ADJ_GOVERNANCE_PHASE_END_DATE),ADJ_GOVERNANCE_PHASE_START_DATE-date(today()),ADJ_GOVERNANCE_PHASE_TAT)

Labels (2)
1 Solution

Accepted Solutions
MVP
MVP

@cbaqir  In chart properties->Axis-> Static Min and Static Max expression causing this issue. Uncheck that

View solution in original post

11 Replies
Partner
Partner

What's the output in ADJ_GOVERNANCE_PHASE_START_DATE? You need to ensure it hold a date value. 

You are saying that you are using date#(), but your definition is written without #.

Try this to verify that your field is a date. 

Date (date#("ADJ_GOVERNANCE_PHASE_START_DATE", 'MM/DD/YYYY')) as ADJ_GOVERNANCE_PHASE_START_DATE,

 

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Specialist
Specialist

Unfortunately, that did not make a difference.

Specialist
Specialist

I use that field in lots of other places and it works fine. I'm not sure why this view does not show it correctly.

Specialist
Specialist

QVW Attached

MVP
MVP

@cbaqir  In chart properties->Axis-> Static Min and Static Max expression causing this issue. Uncheck that

View solution in original post

Specialist
Specialist

That definitely fixed part of the issue! Thanks. The dates still aren't formatted correctly though. Any idea?

 

2020-10-21_7-03-51.jpg

MVP
MVP

@cbaqir  that probably due to Date# applied. As you already formatted that field as Date no need to use Date#

Specialist
Specialist

That doesn't seem to fix it.

2020-10-21_7-21-24.jpg

Specialist
Specialist

@Kush Close but not quite. I've been playing with this: =if(not match(ADJ_GOVERNANCE_PHASE,'5.2 - Ticket Completion'), date(ADJ_GOVERNANCE_PHASE_START_DATE,'M/D/YYYY'))