Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jblomqvist
Valued Contributor

How can I do a Master Calender for multiple date fields in a single original table?

Hi all,

How can I do a Master Calender for multiple date fields in a single original table?

Example:

TableA:

OrderID,

ItemNo

Quantity

OrderDate,

Value,

DueDate,

Discount

From TableA

The above table has two date fields OrderDate and DueDate.

I assume doing two Master Calenders, one for each date field would not be a great solution.

Are there any better alternatives?

1 Solution

Accepted Solutions

Re: How can I do a Master Calender for multiple date fields in a single original table?

Look at Canonical date concept: Canonical Date

1 Reply

Re: How can I do a Master Calender for multiple date fields in a single original table?

Look at Canonical date concept: Canonical Date