NetWorkDays

[PGesterkamp]

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]

Hi PGesterkamp

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

It sounds strange the function not working, because this is a functionality of both script and graphs:  https://help.qlik.com/en-US/sense-kubernetes/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeF...

Good luck,

Marcos

[PGesterkamp]

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

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

[MayilVahanan · Accepted solution]

Hi @PGesterkamp 

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]

UR my Hero!....

Thanks a lot!