Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
PGesterkamp
Contributor III
Contributor III

NetWorkDays

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

1 Solution

Accepted Solutions
MayilVahanan

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;

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

4 Replies
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
Contributor III
Contributor III
Author

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

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

MayilVahanan

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;

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
PGesterkamp
Contributor III
Contributor III
Author

UR my Hero!....

Thanks a lot!