Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

need calculation of days,hour & min

hey guys ,

I need to calculate the no of working days (excluding the weekends) , hours and minutes to close the case for the following table.

for null filed it will take system time.

Please help

Tags (1)
6 Replies
Highlighted
Specialist II
Specialist II

Re: need calculation of days,hour & min

To find the number of working days, use:

networkdays

Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

example:
networkdays (startdate, enddate, holidaydate1, holidaydate2,holidaydate3,holidaydate4.......)

Highlighted
MVP
MVP

Re: need calculation of days,hour & min

Highlighted
Not applicable

Re: need calculation of days,hour & min

but for the last one it will not work?

Highlighted
Creator III
Creator III

Re: need calculation of days,hour & min

Hello Amit,

see attached file. Hope it helps.

BR

M

Highlighted
Not applicable

Re: need calculation of days,hour & min

i am not seeing any attached file martin

Highlighted
Creator III
Creator III

Re: need calculation of days,hour & min

-►