Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!)
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.
Perhaps this could help: Canonical Date
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.
Is there a possibility that I can say in my loading script
wo_transfer_dimension:
LOAD
due_at as date(due_at + MFG _Date);
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.