Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

shrutithakur297
Registered User

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

Tags (1)
2 Replies

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

Where is the list of Holidays?

shivanandk
Contributor II

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

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...

Community Browser