Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
jim_chan
Contributor III

How to create a Master Calendar for such date fields?

Hi guys,

I would like to add in a master calendar in my qlikview app.

In my orders table - there are OrderDate, Year, and other fields.

In my sales_target tabble there are Month, Year and other fields.

I dont know how to create a master calendar with such fields...

Rgds

Jim

Tags (2)
2 Replies

Re: How to create a Master Calendar for such date fields?

With such fields? You mean with multiple dates in your app? May be see this

Canonical Date

qlikdash
Valued Contributor

Re: How to create a Master Calendar for such date fields?

How to Create a Master Calendar with 3 Fact Tables

Hi Jim,

I had a similar scenario. check out the link above in addition to sunny's suggestion.

HTH