Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shrutithakur297

Find No of working days excluding sat sun and holiday list?

Hi ,

Please help in calculating no. of days in  the below data file.

    

[Issue key]CreatedCreated_DateCreated_today(today()-Created_Date)+1
GEMPRODSUP-427504/May/18 2:07 PM04/05/201811/05/20188
GEMPRODSUP-427904/May/18 4:43 PM04/05/201811/05/20188
GEMPRODSUP-423403/May/18 9:52 AM03/05/201811/05/20189
GEMPRODSUP-423503/May/18 9:57 AM03/05/201811/05/20189
GEMPRODSUP-423603/May/18 9:59 AM03/05/201811/05/20189
GEMPRODSUP-397626/Apr/18 7:24 PM26/04/201811/05/201816
GEMPRODSUP-397726/Apr/18 7:59 PM26/04/201811/05/201816
GPS-273426/Apr/18 2:31 PM26/04/201811/05/201816
GEMPRODSUP-386425/Apr/18 9:34 AM25/04/201811/05/201817
GEMPRODSUP-386525/Apr/18 9:51 AM25/04/201811/05/201817
GEMPRODSUP-386625/Apr/18 10:26 AM25/04/201811/05/201817
GEMPRODSUP-438009/May/18 5:21 PM09/05/201811/05/20183
GEMPRODSUP-438209/May/18 6:07 PM09/05/201811/05/20183
GEMPRODSUP-433308/May/18 8:32 AM08/05/201811/05/20184

Thanks and regards,

Shruti Thakur

2 Replies
sunny_talwar

Where is the list of Holidays?

shivanandk
Partner - Creator II
Partner - Creator II

Check the function networkdays, firstworkdate, lastworkdate

The functions returns date or days between and including start_date and end_date taking into account any optionally listed holiday.

Below is the sample example

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/ne...

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/la...

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/fi...