Master Calander creation

[VishalSingh18]

Hello Experts,

I am a new user to qlikview

and in my app I have many date fields from different data sources(e.g: createddate, InvDate, TerminationDate and many more)

I want to know how can I combine these date fields to a single date field which contains all the dates between oldest date in all of the date field and the most recent date

Thanks in Advance

Regards

Vishal Singh

[Ezirraffner]

Hello @VishalSingh18 ,

The links below can help you

https://community.qlik.com/t5/Qlik-Sense-Documents-Videos/Understanding-the-Master-Calendar-video/ta...

https://community.qlik.com/t5/QlikView-Documents/Master-Calendar-Generation-Script/ta-p/1477450

https://community.qlik.com/t5/QlikView-Documents/Master-Calendar-Data/ta-p/1477133

Regards,

Ezi

[dplr-rn]

Adding to what azir mentioned.

if you need date selections based on multiple fields. i would also use a technique called Canonical date

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

also use below link for a more efficient calendar script

https://qlikviewcookbook.com/2015/05/better-calendar-scripts/

[Brett_Bleess · Accepted solution]

The only thing I see missing is the following Design Blog post on Master Calendar:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

Please be sure you circle back to your post to close things out, so if any of the posts helped you resolve things, use the Accept as Solution button on the post(s) that helped to mark them, as this gives the poster credit for the help and lets other Members know what worked.  If you have further questions, please leave an update on what you still need.

Here is base link to the Design Blog area, lots of how-to posts out here, over 700, so be sure to bookmark this one and search it, as you should be able to find a lot of useful topics there.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett