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...
...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...
Hi, I'm having an issue with mastercalendar and session access on Qlik Sense (Saas). My Session Access Script, use the field [ID_LOCATION] as REDUCTION to reduce data for each user, but t...
I'll share these scripts as they are very often requested and useful both in simple and advanced QlikView / Qlik Sense applications. Please also look for other kind of mastercalendars t...
Hi everyone My first timestamp mastercalendar generator - generates every minute timestamp start 2007-01-01 till Today() Hope you like it, Mike P.S. beginner in qlik
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...
Hi community, I have the need in my model to create muitple mastercalendars, as I have many dates. I'm talking about 7 mastercalendars. I'm loading them and LEFT KEEPing them with my FACTS table....
...020, the fiscal year returned should be FY19 opposed to FY20. I am also unable to use MAX(Year Sequence) because our master cal has dates through 2030, so the max year number would be for 2030 instead o...