Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Time taken to close the Service Requests from Open Status

Hi,

I would like to have KPIs prepared for example when we are having a service request in "Open" Status and would like to check Average time taken to close the ticket.SR with Open status being in one File and Same SR with Closed Status.I would like to calculate no of days taken and Average Time Taken to close the SR.

2 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try Interval() to get the time difference between dates in days minutes format.

Regards,

Jagan.

jagan
Luminary Alumni
Luminary Alumni

Refer Qlikview help file for reference.

Example:

interval(EndDate - StartDate, 'D hh:mm' )