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;

[@BonJunCuevas]

Thanks for sharing. I Always learn new techniques from your channel.

[@GuilhermeApprobato]

Thank you!

[@Robert8455]

Thanks Guilherme. You always present great learning nuggets that are easy to follow and understand.

[@GuilhermeApprobato]

Thanks for the feedback Robert! 😁

[@narband2778]

Great Stuff... Can I know which screen snippet you are using! That's amazing!!

[@GuilhermeApprobato]

Thanks! It is called ZoomIt , you can draw on the screen, quite good