Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Response Time

Hi Everyone,

Hope to seek your kind assistance with this task I'm stuck with. In the table below, it shows the following columns. Here's a few things you may want to take note:

  1. InstalledProductNumber have Onsite Service and Remote Service
  2. CreatedDate for an InstalledProductNumber is always the same for Onsite or Remote
  3. There could be multiple StartDateTime for Onsite Service and could be the same for Remote Service
  4. The earliest StartDateTime of Onsite Service and Remote Service are used for comparison (in First Start Column)

tabletable

 

This graph below shows the response time of Onsite Service and Remote Service.

Onsite-Remote.JPG

 

This brings me to my question..

If the earliest StartDateTime of Remote Service starts later than the earliest Onsite Service, I would like to change the Remote Service Response time to 0, meaning I would only like to show the dark orange part with 03:12:09

But if the earliest StartDateTime of Onsite Service starts later than earliest Remote Service, I would like the graph to remain exactly the same as above.

Can somebody please advise me with some functions I could use? Much appreciated!

PS: i have attached the sample data in Excel for your reference.

0 Replies