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...
...cale) is based on the generated autoCalendar only. I tried different ways to use the continuous scale based on persistently stored fields in the data model (like a manually created mastercalendar), but t...
Managing Master items can be time consuming. Master Items can also become difficult to maintain and validate as more are created, risking consistency in your development. To solve t...
Trouble maintaining your Master Items in Qlik Sense? Look no further, GINQO's Master Item Manager has been further improved. Master Items can be difficult to maintain as you create more of them, w...
The first part of this file is a Qlik load script section that creates a fiscal calendar table (FiscalCal) based on an existing date field ( has already been loaded - typically in a fact table).&n...
Hi all,
I have prepared a script that will calculate the MTD, YTD, QTD, WTD without using complex set analysis using the As-Of table concept.
One more App is attached : Which c...
...ere was to streamline the creation of a MasterCalendar and time dimensions based on one or more than one (if required) important dates on your data model. This subprocess creates several tables t...
Time Analysis Code.txt (23 KB)
My 2c on Time Analysis.pdf (1,181 KB)