Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
MVP
MVP

Re: Date from QVD not exactly the same as Source

It is not needed if you format the date fields in the right way before you STORE the QVD.

So, if you have Oracle as source then add a preceding LOAD with Date() or Timestamp() function:

MyTable:

LOAD Date(MyField, ''MM/DD/YYYY hh:mm:ss TT') as MyDate, ... ;

SQL SELECT MyField, ...  FROM Table;

- Ralf

Highlighted
Not applicable

Re: Date from QVD not exactly the same as Source

Got it. Thanks Ralf

Community Browser