4-4-5 Calender w/multiple Date Keys

scottan1 — Sat, 16 Nov 2024 20:44:52 GMT

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.

topic 4-4-5 Calender w/multiple Date Keys in QlikView

4-4-5 Calender w/multiple Date Keys