topic NetWorkDays in QlikView

NetWorkDays

PGesterkamp — Mon, 26 Jan 2026 18:19:17 GMT

Hi there

How can i calculate the netto workdays in a script for QlikView

The string in SetAnalysis gives the correct output..... NetWorkDays(Besteldatum, Afleverdatum)

Problem is that i need de output as a dimension value! and the string above does not work in my script.

How can i solve this?

Thanks in advance

Marcos_Ferreira_dos_Santos — Tue, 27 Apr 2021 12:07:55 GMT

Hi PGesterkamp

Have you solved this issue by yourself ? I hope so.

Good luck,

Marcos

PGesterkamp — Mon, 03 May 2021 09:20:03 GMT

Sorry. it does not work. it gives an error like:

'NetWorkDays' is a not recognized built-in functioin name

MayilVahanan — Mon, 03 May 2021 10:26:48 GMT

I think, u used the networkdays function in SQL Query. If so, try with preceding load like below

Load *, NetWorkDays(Besteldatum, Afleverdatum) As Datum;

SQL Select .. from yoursouce;

PGesterkamp — Tue, 04 May 2021 04:58:46 GMT

UR my Hero!....

Thanks a lot!