Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
The NetWorkDays function in QlikView only considers Monday to Friday when calculating the difference between two dates.
I have been asked to include Saturday as a working day.
I calculate the lead time for an activity in the script of my QlikView report (see below) so that I can then use Median(LeadTime) in the Pivot Table in my report.
NetWorkDays(%_CreatedOn, %_ScheduledOn)-1 as LeadTime
Has anyone included Saturdays in a similar calculation? How did you do it?
I have a calendar dimension that has a DayCount field (Monday to Friday is 1, Saturday and Sunday are 0).
Heres a thread that may be of help to you