Skip to content

Instantly share code, notes, and snippets.

@ralfbecher

ralfbecher/QlikView_Networkdays_including_Saturday.qvs

Last active December 12, 2015 08:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ralfbecher/4741991 to your computer and use it in GitHub Desktop.
Save ralfbecher/4741991 to your computer and use it in GitHub Desktop.
Download ZIP
Calculate Networkdays with Saturday included in QlikView
Raw
QlikView_Networkdays_including_Saturday.qvs
Load
floor(((Date2 - Date1)+1)/7)*6 + mod((Date2 - Date1)+1,7)
+ if(Weekday(Date1) + mod((Date2 - Date1)+1,7) < 7, 0, -1) as Workingdays_6
...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment