Calendars in Qlik Sense and how to deal with them

[@UlsterMorales]

Thank you very much, your video helped me to expand my knowledge.

[@JoseRavanalSeron]

Hi!!.. your expertise is awesome, thank a lot!!

[@datafriendly]

Hey, thanks!

[@tejaswinich1474]

can you please explain auto calendar functionality in qliksense and how it can be used to calculate Last year Till date sales in comparison to current year

[@datafriendly]

Hi, unfortunately I'm not doing videos about Qlik Sense anymore.

[@rams_stuff]

Thanks 🙏. It's helped me

[@datafriendly]

Welcome 😊

[@andreorla91]

Thank you for this video, this helped me a lot to make comparison between my projects data (expected data, actual data, start and finishing) and accounting ones. Why are you recommending Master Calendar and not Canonical Date?

[@datafriendly]

I worked slightly better for me. I'll make a separate video about canonical date in the future.

[@harishkumar-fi1zk]

You have created a single date column called Planned_Date using union all .
Have you later created master calendar using this Planned_Date?

[@datafriendly]

In this case it's not necessary as all dates are in one column. But if you would connect some other table by date field - than it would be good to create it.

[@robdekoning1146]

You can use something called a "Canonical date/calendar" in qlik

[@datafriendly]

Yes, it's possible. Though it's not the best solution in some cases.