Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

robbiewottie
New Contributor II

1 Master calendar for two dates from seperate fact tables

Hi Guys,

I'm facing the following problem.

I have two fact tables with two important dates which I need to combine into one master calendar. As link these fact tables I have a compound key with dimensions A+B and stored the shared dimensions into a Link Table.

Now is the question whats the best way how to develop one master calendar that can be used to analyse records from fact table A and fact table B. 

Best regards,

Robert

3 Replies

Re: 1 Master calendar for two dates from seperate fact tables

karthigayan
Contributor II

Re: 1 Master calendar for two dates from seperate fact tables

Say for Ex : if u have OrderDate and SalesDate

Generate the mastercalendar like this

Start Date in MasterCalendar -minimum(StartDate_OrderDate,StartDate_SalesDate)

End Date in MasterCalendar -Maximum(EndDate_OrderDate,EndDate_SalesDate)

Re: 1 Master calendar for two dates from seperate fact tables

If the dates are really different (Eg. Stat and End Date) then you need 2 master calendar to manage them, otherways if dates from 2 or more tables represent an omogeneous information one calendar is enough.

If you look in the community you will find lots of calendar that starts from the min(date) up to the max date and implement values like month, year, week and so on

Community Browser