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: 
jerryr125
Creator III
Creator III

Networkdays Question

Hi - I have a question about the Networkdays function.

I presently have the following in my dataload:

 

Today(1) - Date(Date#(abcddate,'YYYYMMDD'),'MMDDYYYY') as NumberofDays

 

Works perfectly BUT I want to remove Saturday/Sunday from the calculation.

Give the current format above of the date fields, what is the best way to approach this with the Networkdays function?

 

Thanks - Jerry

Labels (2)
1 Solution

Accepted Solutions
danielrozental
Master II
Master II

You should try something like

Networkdays(Date#(abcddate,'YYYYMMDD'),today(1)) as NumberofNetworkDays

Qlik Sense NetworkDays  

View solution in original post

1 Reply
danielrozental
Master II
Master II

You should try something like

Networkdays(Date#(abcddate,'YYYYMMDD'),today(1)) as NumberofNetworkDays

Qlik Sense NetworkDays