Create LinkTable for creating MasterCalendar

[jjordaan]

Hello QlikView lovers,

I am working on a QV app to create a data model.
I try wherever possible to work towards a Star model. So I created a facttable called 'Transactions'  (Sales Lines, Purchase Lines).
The original sales lines contain 2 date fields and the original purchase lines 4.
Through a Link Table I want to place alle the date fields into the LinkTable so I can then created a MasterCalender out of the LinkTable.
I only got $ Syn keys because all the fields are from the same table wich I created through the concatenate  action.

I'm totally stuck with this problem

How do I fix this?

As an attachment I attached an example QVW and the 2 QVD's wich contains the data.

Thanks for the help.

[pgalvezt]

Hi, Could you please mark as Answer correct so the others can consult this problem.

Thanks

[jjordaan]

My question is not answered.

I hope I could answered the question of PurnaC10.

[#4]

Sorry for the confusion. You have answerd my question.

[#5]

I'm able to create master calender, but how do i create master calender with hours and mins granularity. I tried to pass date-hours-mins-sec to master calnder script but it failing with File Not Found error. Otherwise it works fine with only date value.

How do i create a MC include hours and mins.

[jjordaan]

PurnacC10,

Can you attach an example?

If date field in the database is a DateTime field everything should go fine.

In the Mastercalendar you can add a field like DateTime or something and the you have the datetime.

In the Mastercalendar you also extract the year, month and so on. With that fields you don't have an timestamp but is abvious because you extract onley the year or month.

[#7]

I'm uploading the QVD. you can see a note on Data01 column format. Please let me know if you have any questions.

Thanks.

[jjordaan]

Is the script running in SQL Server?

I think it won't because of the DateTime function?

[#9]

It is in Oracle. ie. Oracle is my data source.