I'm quite new to qlikview so forgive me for my ignorance.
I have created a MasterCalander and added the Networkdays function in it. By doing this I would like the weekends to automatically be removed. However I don't know if this is the right approch. The main goal is to automatically remove all the weekends between the departure date (DEP) field en arrival date (ARR) field.
I tried something myself.
This is my script.
LET varMin = num('01-01-2011');
LET varMax = num('31-12-2011');
LET vWorkDays = NetWorkDays('01-01-2011', '31-12-2011'); //does not work
Load Date($(varMin), ($(vWorkDays)) + rowno() -1) as tempdate
AutoGenerate ($(varMax) - $(varMin)) - $(vWorkDays) +1; //does not work
Date(Date#(DEP,'DD-MM-YYYY hh:mm'), 'DD-MM-YYYY') as DEP,
Trim(Date(Date#(DEP,'DD-MM-YYYY hh:mm'), 'DD-MM-YYYY')) as Date,
Date(Date#([ARR/NFD],'DD-MM-YYYY hh:mm'), 'DD-MM-YYYY') as ARR,