Qlik Sense - Must Know Tips #11 | How Dates work + Master Calendar
Understand how dates are converted into numbers and vice versa using the most common date functions.
Check out the other videos with Qlik Tips and subscribe!
Linkedin: / guilhermeapprobato
---------------------------------------------------------------------
Master Calendar code used (Notice that you need to replace the placeholder of the minor sign since I can't add it here in the description):
TMP_MasterCalendar:
Load
Min(Date) as mindate,
Max(Date) as maxdate
resident Table;
let vmindate = peek('mindate');
let vmaxdate = peek('maxdate');
MasterCalendar:
Load *,
Year(Date) as Year,
ceil(month(Date)/3) as Quarter,
Month(Date) as Month,
Day(Date) as Day;
Load
Date($(vmindate) + Iterno() -1 ) as Date
Autogenerate 1
while
$(vmindate) + Iterno() -1 [change for minor sign]= $(vmaxdate);
Drop table TMP_MaterCalendar;