Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Difference DateTime on working days

Hi!

I am having trouble getting results. I have the following table:

IDDATE_STARTDATE_END
34209834282020-06-30 17:05:362020-07-01 14:00:19
54835430432020-07-01 16:36:582020-07-03 13:48:54
92309193212020-06-03 11:14:452020-06-05 18:00:02
75439349002019-12-18 14:24:462019-12-23 17:29:49
43209321982019-07-22 16:53:172019-08-02 10:04:24
69458324122019-08-06 11:32:582019-08-21 14:12:23
12091923192020-06-12 19:26:272020-07-03 16:15:16
28298192852020-02-03 16:21:032020-03-05 11:46:06
84329907732019-05-15 00:07:012019-08-16 10:09:15
94394394412019-08-20 10:55:42-

 

First I would need to get an expression that would give me the number of working days, hours, minutes and seconds between DATE_START and DATE_END. In case DATE_END is NULL (like the last record) it should take today's date.

Then, I must obtain the average working hours based on the filters that I have selected in my dashboard.

Please could any one help me?

Thank you very much!

Regards,

 

Martín

2 Replies
Highlighted
MVP
MVP

Is there any specific requirements to exclude non working days or holiday?

Highlighted
Contributor III
Contributor III

Hi @Kush! Only working days.

Regards!