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: 
Anonymous
Not applicable

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

swuehl
MVP
MVP

Anonymous
Not applicable
Author

Excellent, thanks!