Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

shrutithakur297
New Contributor

How to count working hours taken(8 hrs a day) time from Created and Resolved date ?

Hi,

It will be really helpful if anyone of you can help me. I am struggling to get it done from days.

1. I need to find working hours taken taking 8 hrs a day

2. Add new column having value Success and Breach on Severity field as mentioned below :

       

CreatedResolvedCustom field (Severity)Interval (Timestamp#(Resolved,'DD/MMM/YY hh:mm tt') - Timestamp#(Created,'DD/MMM/YY hh:mm tt'), 'h') TIME RANGE
12/Mar/18 3:22 PM12/Mar/18 3:40 PMS1-Critical01S1-Critical1 HRSUCCESS
12/Apr/18 2:19 PM12/Apr/18 2:36 PMS3-Moderate02S2-Serious4HRSUCCESS
11/May/18 11:19 AM11/May/18 11:36 AMS3-Moderate03S3-Moderate16 HRSUCCESS
18/Apr/18 4:26 PM18/Apr/18 4:41 PMS4-Tolerable04S4-Tolerable16 HRSUCCESS
13/Mar/18 12:32 PM13/Mar/18 12:46 PMS1-Critical05BLANKBLANKBREACH
25/Apr/18 9:34 AM25/Apr/18 9:45 AMS3-Moderate06 >16 HRBREACH
28/Mar/18 4:45 PM28/Mar/18 8:13 PMS3-Moderate3 **WORKING HOURS MEANS 9-5 PM 8 HRS A DAY
3 Replies
krishna_2644
Valued Contributor III

Re: How to count working hours taken(8 hrs a day) time from Created and Resolved date ?

Ye haath muje dede thakurr...haha..just kidding..

Can you please explain a bit in detail?

1. I need to find working hours taken taking 8 hrs a day - So you want to populate 8hrs for each row in a seperate column?

2. Add new column having value Success and Breach on Severity field as mentioned below : - need more clarity on this? please elaborate.

eduardo_dimperi
Valued Contributor II

Re: How to count working hours taken(8 hrs a day) time from Created and Resolved date ?

Hi,

1 -But how proceed if you get more than 8 hours a day or if you have less then 8 hours but out range (9-5pm)?

2- How works that definition of Success and Breach?

zebhashmi
Valued Contributor

Re: How to count working hours taken(8 hrs a day) time from Created and Resolved date ?

if([Custom field] = 'S1-Critical' AND Interval (Timestamp#(Resolved,'DD/MMM/YY hh:mm tt') - Timestamp#(Created,'DD/MMM/YY hh:mm tt'), 'h')<1, 'SUCESS',if([Custom field] = 'S2-Serious' AND Interval (Timestamp#(Resolved,'DD/MMM/YY hh:mm tt') - Timestamp#(Created,'DD/MMM/YY hh:mm tt'), 'h')<4, 'SUCESS', and so on..


you can use Match and pick for that as well