Discussion board where members can get started with Qlik Sense.
networkdays (min([Work Date]), max([Work Date]))
in script two steps to go there
min([Work Date]) as MinDate,
max([Work Date]) as MaxDate
NetWorkDays(peek(MinDate,0,'Temp'),Peek(MaxDate,0,'Temp')) as WD
Drop Table Test;
Please convert Work Date as Start & End Date.
Then use - NetWorkDays([Start Date],[End Date])
if you want you can specify holidays as well. Please check the below example.
need to specify the holidays in networkday().
For example you want networkdays between 2006-12-18 and 2006-12-31.
If you just give this without the specific holidays you will get 10 as output.
But say you have holiday on 2006-12-25 and 2006-12-26
Then specify like this
networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26')
and you will get answer as 8.