In this video I will introduce you to a concept known as the MasterCalendar which can be used with both QlikView and Qlik Sense. A MasterCalendar is simply a table that contains a time p...
I have dataset and in the dataset date column available and format is DD/MM/YYYY. Question is Based on that i want to create an mastercalendar. How to create in data load editor?
...s, creating current year to date vs last year to date, and matching dates between two date fields are all things that have come up. The answer to all of these is to create a mastercalendar.&n...
I have tried but seems my Mastercalendar just wont work for my 2 variables i.e. Purchases and Usage. I have attached the application it would appear my graphs are showing incorrect calculations. I w...
Hi there,
I would like to create a mastercalendar for some sales comparisons between different years. I used the follow script: Creating A MasterCalendar - Qlik Community - 341286
But I h...
Hello All, I was trying to build mastercalendar in Qlik based on Sales Date column in Sales table, but I am getting only 2021 may 5th date for whole calendar table but I am having dates t...
Hello Experts,
I have Two Calendars; one is Auto Calendar and another one is MasterCalendar. Script for both Calendars are attached.
First of all, I would like to know the d...
Hi guys I have some questions about MasterCalendar. I tried, but i really don't understand what is a MasterCalendar, how to use it and something about the advantage of using a MasterCalendar i...