Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist II
Specialist II

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
Kushal_Chawda

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

View solution in original post

11 Replies
Vegar
MVP
MVP

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,

 

 

cbaqir
Specialist II
Specialist II
Author

Unfortunately, that did not make a difference.

cbaqir
Specialist II
Specialist II
Author

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.

cbaqir
Specialist II
Specialist II
Author

QVW Attached

Kushal_Chawda

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

cbaqir
Specialist II
Specialist II
Author

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

Kushal_Chawda

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

cbaqir
Specialist II
Specialist II
Author

That doesn't seem to fix it.

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

cbaqir
Specialist II
Specialist II
Author

@Kushal_Chawda 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'))