Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mvajhuddart
New Contributor

Date as Measure in Table

I am trying to add a field to a table which shows the earliest estimated delivery date of a product. The field comes through fine as a dimension in a table, but when I try to add it as a measure (using MIN([Estimated Delivery]) ) then I just get blank values.

QS Table.png

Any ideas why this might be happening and what the solution is?

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Date as Measure in Table

It is actually not coming in as date. See how it is left oriented, if it was truly a date field, it would have been right oriented. Try this in the script:

LOAD Date#([Estimated Delivery], 'DD-MMM-YY') as [Estimated Delivery]

FROM Source

UPDATE: Look at the following links

Why don’t my dates work?

Get the Dates Right

3 Replies
MVP
MVP

Re: Date as Measure in Table

It is actually not coming in as date. See how it is left oriented, if it was truly a date field, it would have been right oriented. Try this in the script:

LOAD Date#([Estimated Delivery], 'DD-MMM-YY') as [Estimated Delivery]

FROM Source

UPDATE: Look at the following links

Why don’t my dates work?

Get the Dates Right

MVP
MVP

Re: Date as Measure in Table

mvajhuddart
New Contributor

Re: Date as Measure in Table

Excellent, thanks!