topic Re: Creating a Calendar based on two inputs? in QlikView

Creating a Calendar based on two inputs?

Tue, 28 Jul 2015 10:11:23 GMT

Dear QlikViewers,

My following question is regarding making a calendar based on two values that make a Date. This is the issue:

The date that I want is generated by two values. MFG_date + due_at. So I can create a listbox with the expression below and it shows the correct Date. (MFG_Date is a Date, due_at is a number. The due_at value is the number of days since MFG_Date.

However I want to create a MasterCalendar for this Date. Normally I would simply create the master calendar and link it to the table, but now the date is generated from two tables. So I think I cannot do this. WITHOUT joining all these tables. (which I do not want to do)

My question, is there a way to generate this MasterCalendar for the Date I want. (I know how to generate a Calendar!)

Re: Creating a Calendar based on two inputs?

tresB — Tue, 28 Jul 2015 10:30:33 GMT

Perhaps this could help: Canonical Date

Re: Creating a Calendar based on two inputs?

Tue, 28 Jul 2015 13:07:28 GMT

I'm not too sure if a Canonical Date is a solution for this, as this example is basically one date. But in order to construct the date you need to add a certain number to the existing MFG_Date.

Re: Creating a Calendar based on two inputs?

Tue, 28 Jul 2015 13:37:32 GMT

Is there a possibility that I can say in my loading script

wo_transfer_dimension:

LOAD

due_at as date(due_at + MFG _Date);

Re: Creating a Calendar based on two inputs?

Tue, 28 Jul 2015 15:32:48 GMT

I have just joined the mfg_date with the due_at, so that i could calculate the new date in a new defined table. It works. Still curious if there is the way I described above.