Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi. have you tried using the networkdays function?
see this link for help on the function:
http://www.learnqlickview.com/qlikview-functions-networkdays/
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)