Occupancy count using master calendar

[#1]

Hi,

I am new to Qlik and please be nice to me.

Let's say we are running a hotel, and we record each guest's arrival and checkout dates.

Guest #	Arrival Date	Checkout Date
1	1/1/2016	20/1/2016
2	3/1/2016	14/1/2016
3	16/1/2016	31/1/2016
4	19/1/2016	NULL

And I want to plot a chart to report the occupancy (guest count) of the hotel on each given date.

How would QlikView do it?

Michael

[Gysbert_Wassenaar · Accepted solution]

See this blog post for one solution to this problem: Creating Reference Dates for Intervals

[#3]

It is a valid solution to my problem.

Thanks

Michael