Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
scottan1
Contributor II
Contributor II

4-4-5 Calender w/multiple Date Keys

Hello,

Here's a high level summary of what I'm trying to accomplish:

 

1. 4-4-5 Calendar that starts on Jan 1, ends Dec 31st (so not a traditional retail calendar) - also, needs to fit with 52 & 53 week years.

2. Calendar must co-operate with 2 different date keys (I have two data sources and I can't concatenate the records)

 

What's the best way to approach this problem? Every calendar tutorial for 4-4-5 has a traditional calendar that starts in September and ends in April (which is not what we do here). 

Would I be using a Link Table for the dates? Everything I try ends in failure. Thoughts? Thanks.

 

Labels (3)
0 Replies