Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-04-22 09:38 PM

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

228 Views
0 Likes
0 Replies