Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mvajhuddart
Contributor
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?

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

3 Replies
sunny_talwar

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

View solution in original post

swuehl
MVP
MVP

mvajhuddart
Contributor
Contributor
Author

Excellent, thanks!