Working with Multiple Dates or Calendars in Qlik™

This topic has been covered before, by Qlik™, but they have found out there is a new generation of Qlik™ users and it seems that some of the content not always easily explained.

Do you need answers for specific points in time when working with multiple calendars or dates? Then use a calendar bridge.

A calendar bridge is used to create what Qlik™ commonly calls: a Canonical Date or a Canonical Calendar. A calendar bridge is nothing more than a simple table that links 1 or more dates to a single common date, called a canonical date. This is used to simplify time period selection during analysis and when multiple calendar / date filters can be confusing to the user.  The bridge table is linked to a key field in your data and created with a new dimension to simply describe each date type you have. (You can link this to a Master Calendar if you require more granular time periods.) Your charts can then use aggregated measures with the defined date type in a set expression to show the specific results.

In the video below, you will learn specific answers for certain moments in time when working with multiple calendars or dates.

Play Video

You can also watch below a video about the traditional Master Calendar which can be used with both QlikView™ and Qlik Sense™.  A Master Calendar is simply a table that contains a time period and time attributes that you define, linked to your existing data.

If you are unable to analyze data by different time dimensions using your existing data set, or have noticed time gaps when create charts and visualizations – the Master Calendar will solve these problems.

Please be aware that the Master Calendar can be created a few different ways using Qlik™ scripting. It can also be made more efficient using specific methods and functions.

Play Video

For information about Qlik™, please visit this site:
For specific and specialized solutions from QQinfo, please visit this page: QQsolutions.
In order to be in touch with the latest news in the field, unique solutions explained, but also with our personal perspectives regarding the world of management, data and analytics, we recommend the QQblog !