topic Holiday scenario in QlikView

Holiday scenario

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

emp_id	Sheetdate	task	Workedhours
1	1/1/2017	1	6
1	1/1/2017	2	2
1	1/1/2017	3	3
2	1/1/2017	1	1
2	1/1/2017	2	8
2	1/1/2017	3	1
1	1/2/2017	4	5
1	1/2/2017	5	4
2	1/2/2017	4	4
2	1/2/2017	5	4

i have entered in time sheet for worked hours in daily basis. if not entered Saturday, Sunday and any other holidays. but i want to only entered worked hours for month wise per employee, not considered not entered days. if i select master calendar in month wise it will show only entered days calculate and show. please suggest!

Re: Holiday scenario

adamdavi3s — Tue, 03 Jan 2017 09:59:57 GMT

I'm not really understanding your question, but can you simply add a 'working day' flag to your master calendar and then use this?

Is your question you want to show ALL dates regardless of information entered

Show ONLY working dates?

Re: Holiday scenario

Anonymous — Tue, 03 Jan 2017 10:25:44 GMT

Hi, use Networkdays function, you have to pass start and end date, and a list of holiday days.

Regards!!