Date Format in QVDs not being recognized by Master Calendar

Wed, 25 Nov 2020 16:16:04 GMT

I have an extract script to create a QVD of a Master Data base on the last day of every month so I can keep a historical record of the changes to that database. The creation of that QVD looks like this...

ODBC CONNECT TO JDE_9 (XUserId is XXX, XPassword is YYY);

Master:

Load*,

MonthEnd(Today()) as MonthEnd

;

SQL Select

FACO,

FADL01,

FAEQST,

FAMCU,

FANUMB

From "Production".PRODDTA."Master";

When I load the QVD into a QVW and use the MonthEnd field for my Master Calendar, the data is no longer associated. I have attached both the QVD and QVW as a reference for help.

I will need the master calendar to associate the historical views of the master database to the transactions that occurred at that time as well. I expected to use a solution offered in the discussion link below by having a Master Data Base Calendar, and a Transaction Calendar.

http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/‌

Ultimately, I would like to understand how to get the date format correct. Using Date(MonthEnd) as Date did not work.

Thank you.

Re: Date Format in QVDs not being recognized by Master Calendar

sunny_talwar — Thu, 26 Jan 2017 16:43:54 GMT

Try adding the Floor function to your qvd load

AssetFile:

LOAD FACO,

FANUMB,

FADL01,

FAEQST,

FAMCU,

MonthEnd,

Date(Floor(MonthEnd)) as Date

FROM

(qvd);

Re: Date Format in QVDs not being recognized by Master Calendar

sunny_talwar — Thu, 26 Jan 2017 16:45:10 GMT

Re: Date Format in QVDs not being recognized by Master Calendar

Thu, 26 Jan 2017 16:55:20 GMT

Thank you sir!

topic Date Format in QVDs not being recognized by Master Calendar in QlikView

Date Format in QVDs not being recognized by Master Calendar

Re: Date Format in QVDs not being recognized by Master Calendar

Re: Date Format in QVDs not being recognized by Master Calendar

Re: Date Format in QVDs not being recognized by Master Calendar