topic Re: Date shows as 1900 in QlikView

Date shows as 1900

cbaqir — Sat, 16 Nov 2024 17:57:02 GMT

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

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)

Re: Date shows as 1900

Vegar — Mon, 19 Oct 2020 21:14:42 GMT

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,

Re: Date shows as 1900

cbaqir — Mon, 19 Oct 2020 22:26:54 GMT

Unfortunately, that did not make a difference.

Re: Date shows as 1900

cbaqir — Tue, 20 Oct 2020 22:57:46 GMT

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.

Re: Date shows as 1900

cbaqir — Tue, 20 Oct 2020 23:02:33 GMT

QVW Attached

Re: Date shows as 1900

Kushal_Chawda — Tue, 20 Oct 2020 23:19:47 GMT

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

Re: Date shows as 1900

cbaqir — Wed, 21 Oct 2020 14:04:45 GMT

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

Re: Date shows as 1900

Kushal_Chawda — Wed, 21 Oct 2020 14:12:36 GMT

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

Re: Date shows as 1900

cbaqir — Wed, 21 Oct 2020 14:21:52 GMT

That doesn't seem to fix it.

Re: Date shows as 1900

cbaqir — Thu, 22 Oct 2020 23:08:58 GMT

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

Re: Date shows as 1900

Kushal_Chawda — Thu, 22 Oct 2020 23:39:46 GMT

@cbaqir What is the requirement of chart? Because in expression and dimension both place you have used that Date which is causing that issue.

Re: Date shows as 1900

cbaqir — Fri, 23 Oct 2020 14:23:57 GMT

Please see this post: https://community.qlik.com/t5/QlikView-Creating-Analytics/Ticket-Path-Date-Format-and-Calculation/m-p/1755223#M48651