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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need Networkdays

Hi

I have Year and Month fields, I need to show total no of working days of Employee excluding Saturday & Sunday for individual month.

Thanks

2 Replies
Not applicable
Author

hi. have you tried using the networkdays function?

see this link for help on the function:

http://www.learnqlickview.com/qlikview-functions-networkdays/

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You can use the NetWorkDays for this: NetWorkDays( Date1, Date2). If you have no date field then you need to create dates for the start and end date of the month: NetWorkDays(MakeDate(Year,Month), MakeDate(Year,Month+1)-1)


talk is cheap, supply exceeds demand