Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
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
Kush
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
Vegar
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
cbaqir
Specialist
Specialist
Author

Unfortunately, that did not make a difference.

cbaqir
Specialist
Specialist
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
Specialist
Author

QVW Attached

Kush
MVP
MVP

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

View solution in original post

cbaqir
Specialist
Specialist
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

Kush
MVP
MVP

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

cbaqir
Specialist
Specialist
Author

That doesn't seem to fix it.

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

cbaqir
Specialist
Specialist
Author

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