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).