Creating Master Calendar

[Anonymous]

Hello Guys,

I have to create a master calendar .

I have around 200 different projects with unique ids which has :-

a. Start date

b. End date

I have to create a master calendar using auto generate . Kindly help me with this .

My tables looks like this as shown below :-

ID Project	Start date(MMDDYYYY)	End Date(MMDDYYYY)
12	02/02/2015	20/06/2019
34	30/07/2016	04/05/2018
56	26/04/2016	06/07/2019

Along with master calendar , I also need to calculate difference between these two dates(End-Start) in months, days, years and so on.....

Thanks In Advance,

ravi

[shraddha_g]

Refer capture dates in between start date and end date

[teiswamsler]

Hi Shinge

If you use the data maneger to prep the data, Qlik Sense will automatic generate a usable calender base on derived fields

/Teis