You wanted to learn how to work with Multiple Calendars. Here's how.

[@alexis1959]

Thanks Mike - I was the one that asked for "Multiple Calendars" in a recent webinar and voila you've done a video as promised. Look forward to the walkthrough video

[@QlikOfficial]

Awesome! Yes I remembered, lol - happy to assist. Working on the walk-through now. BUT if you don't want to wait and play with it now - if you did not see - there is a blog with a sample app and data to here: community.qlik.com/t5/Design/Let-s-Take-a-walk-on-the-Calendar-Date-Bridge-Working-with/ba-p/2133428 - let me know if you have any questions. Regards, Mike T

[@MrVurtan]

We have such a bridge calendar in our projects as well for easier reporting of time periods like YTD, YTM, Rolling 12 month and so on. That is quite handy and easy to use!

[@KeyBorg1]

We use this design in pretty much all of our apps because we have so many date types. But insight advisor struggles mightily with this construct. I would love to see a video or webinar explaining how insight advisor can suggest workable charts with this model design.

[@QlikOfficial]

Thank you for sharing. That’s great to hear. In regards to Insight advisor I’m still working on part 2 of this video and I think that’s a great topic to also cover I will mention that in the video. In short modifying business logic calendar periods and setting up behaviors Should help with the natural language questions but yes depending on the time. Being asked for you might need to have more specifics in the question for example saying something like “this year” when you have multiple calendar types needs to be more specific unless a behavior is set up and calendar. Is defined I will cover this in the video thank you for your Comment.

[@KeyBorg1]

​@@QlikOfficial thanks so much!

[@sanketkondvilkar0747]

@QlikOfficial The video provided valuable insights, thank you! Anticipating part 2 eagerly…

[@sameerulhaq4066]

what if we have dates in two different tables? Like order date in order table and gl_date in invoice table and want to link them based on year

[@QlikOfficial]

Hi Sameer - that should not be a problem - you would just source your data from the other data connection. How familiar are you with Qlik data connections? We take the data from the source and load it into the app. Then you can link like fields on the same fieldname. I am making video 2 on this soon and I will mention that in the video. Regards, Mike T

[@QlikOfficial]

Do you need specific answers for points in time when working with multiple calendars / dates? Watch this video to learn more. Sample App and Data here: community.qlik.com/t5/Design/Let-s-Take-a-walk-on-the-Calendar-Date-Bridge-Working-with/ba-p/2133428#M9823 This article is a great reference with more detail: community.qlik.com/t5/Design/Canonical-Date/ba-p/1463578 Oh and you want to learn more about the traditional Master Calendar? Check this out: kzbin.info/www/bejne/m5zCeoecq6ihftkfeature=shared Part 2: Coming soon....