topic Re: SLA find out in QlikView

SLA find out

Anonymous — Wed, 18 Mar 2015 10:45:24 GMT

Number	Requested Date	Severity	Resolved
179270	10/02/2015 16:00	5
179260	10/02/2015 14:38	2
179258	10/02/2015 14:17	5
179255	10/02/2015 13:49	5
179254	10/02/2015 13:45	5	10/02/2015 13:55
179241	10/02/2015 11:53	5
179235	10/02/2015 11:06	1	10/02/2015 11:08
179223	10/02/2015 09:25	3	10/02/2015 09:58
179222	10/02/2015 09:13	5
179219	10/02/2015 09:05	3	10/02/2015 09:12
179206	10/02/2015 04:37	5
179200	09/02/2015 17:01	4

From the above list I want to find those records which missed the SLA

We need to consider the below condition-

Severity 1 should be resolved within 3 hours

Severity 2 should be resolved within 5 hours

Severity 3 should be resolved within 3 business days

Severity 4 should be resolved within 5 business days

Severity 5 - No SLA

Business timing should start from 9AM and end - 17PM

Sat sunday are off day

Need to follow holiday-1st may , 25th Dec

If SLA fails then records should mark in RED

If resolved date is null then mark it todays date.

Please help

Re: SLA find out

buzzy996 — Wed, 18 Mar 2015 11:23:04 GMT

The idea is,

1. If Resolved-date have some data u can consider this else u can take today-date,

2. Get Number of hours (Resolved-date-Requested-date) and exclude holiday&weekend hours

3. Compare ur SLA hours with Point number 2 hours and display which are met & not met.

Re: SLA find out

Anonymous — Wed, 18 Mar 2015 13:08:07 GMT

Hi Shiva,

Thanks for your help.

Could you help me more?

Regards

Anutosh

Re: SLA find out

Anonymous — Wed, 18 Mar 2015 14:26:59 GMT

Please help

Re: SLA find out

Anonymous — Wed, 18 Mar 2015 18:18:30 GMT

Please need help on that

Re: SLA find out

Anonymous — Thu, 19 Mar 2015 11:18:52 GMT

I am requesting everyone to help

Re: SLA find out

Mon, 30 Mar 2015 11:09:20 GMT

Hi Suman,

I am very late in responding to you and hope that this thread is alive, please find the attached qvw file. Please note that I have taken date in D/M/YYYY format and also I used gauge to show which record missed SLA instead of putting whole record in RED.

I hope it helps.

Thanks!

Re: SLA find out

Anonymous — Mon, 06 Apr 2015 13:03:32 GMT

I think your example is right. I am modifying according to it.

In the date column it is coming number while implementing your example. Please suggest where could i change that,

Re: SLA find out

Mon, 06 Apr 2015 13:16:05 GMT

Hi,

please follow the below link.

Work minutes

regards

amay

Re: SLA find out

Anonymous — Mon, 06 Apr 2015 14:15:29 GMT

Business timing should start from 9AM and end - 17PM I think is not working properly.

Re: SLA find out

Tue, 07 Apr 2015 09:10:00 GMT

Well, I have taken two variables for start and end time. Can you please paste the example or qvw and exactly how it is violating that business timing?

Thanks,

Abhishek

Re: SLA find out

Tue, 07 Apr 2015 09:17:07 GMT

I assume you are using chart, where you don't need to change anything. Moreover, I am using .csv file as source. Are you using xls? An XL sheet has its own formatting structure, if you are using it as source.

Thanks!

Re: SLA find out

Anonymous — Tue, 07 Apr 2015 09:40:45 GMT

I have attached one xls file.

Many thanks again.

Re: SLA find out

Tue, 07 Apr 2015 10:02:54 GMT

a quick question..I think all the dates in your xls is in MM/DD/YYYY format ( and not in DD/MM/YYYY format), please confirm??? Because in my script I took them as DD/MM/YYYY.

Re: SLA find out

Anonymous — Tue, 07 Apr 2015 10:07:03 GMT

DD/MM/YYYY format.

Re: SLA find out

Tue, 07 Apr 2015 10:55:00 GMT

For Dates that are shown in numbers/decimals, please go to chart->dimension. Click on respective dimension and then at Edit button.

For Request date use: timestamp(num#(RequestDate))

For Resolve date use: if(Index(ResolveDate,'.')>0,Timestamp(Num#(ResolveDate)),ResolveDate)

Please note that all this is done in chart and not in the script.

Hope that helps..

Thanks!

Re: SLA find out

Anonymous — Tue, 07 Apr 2015 11:32:59 GMT

Many thanks I will check and let you know.

Re: SLA find out

Anonymous — Tue, 07 Apr 2015 15:18:52 GMT

The request date and resolve date is working fine.

Comepletiontimeindetails is not giving me the result.

Please help me on that.

Re: SLA find out

Wed, 08 Apr 2015 09:05:02 GMT

What is that in result that you expected from CompleteTimeInDetail?

Re: SLA find out

Anonymous — Wed, 08 Apr 2015 12:22:25 GMT

Time differnece not showing

I want to display <>hour <>minutes