topic Re: Master Calander creation in QlikView

Master Calander creation

VishalSingh18 — Sat, 16 Nov 2024 01:17:20 GMT

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

Re: Master Calander creation

Ezirraffner — Thu, 13 Feb 2020 14:38:19 GMT

Hello @VishalSingh18 ,

The links below can help you

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

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

Re: Master Calander creation

dplr-rn — Thu, 13 Feb 2020 14:42:40 GMT

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/

Re: Master Calander creation

Brett_Bleess — Wed, 11 Mar 2020 15:14:45 GMT

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