Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Design Calendar based on schedule dates & Leave of Absence?

Hi,

I have the following 2 calendar dates ranges.  One is the planned schedule date ranges for individual and the other is the leave date range taken by individual.  I need to know how to design this so I can have a count of number of available people in a schedule date.

I had combine these 2 dates range under one table. the dates ranges is under the columns - Duration Start, Duration End.  Highlight in yellow is the leave of absence. 

How should I design this so I can meet my objective?

Example.

SS.JPG

Thanks

Chun Wey

0 Replies