topic Re: Re: help with a SLA calculation in QlikView https://community.qlik.com/t5/QlikView/help-with-a-SLA-calculation/m-p/523924#M195703 <HTML><HEAD></HEAD><BODY><P>Hi, Thank You very much, but almost there. If you put 10/01/2014 18:30:00 as start time and 13/01/2014 08:40 as end time, the SLA that should be 40 minutes but appears as 10 minutes.</P><P>Can you help me again? The qvw with this new date is attached.</P></BODY></HTML> Fri, 17 Jan 2014 03:05:35 GMT rcandeo 2014-01-17T03:05:35Z help with a SLA calculation https://community.qlik.com/t5/QlikView/help-with-a-SLA-calculation/m-p/523921#M195700 <HTML><HEAD></HEAD><BODY><P>Please help me with the formula in this qvw attached.</P><P></P><P>The objective is calculate the time between the initial and end date, considering only the time between 08:00 and 18:00 hs and ignoring saturdays and sundays.</P><P></P><P>See that lines 1 and 2 are wrong cause the initial date or the end date is in a not a network day. Line one should be 01:00 hour and line 2 should be 01:00 hour too.</P><P></P><P>The other lines are correct</P><P></P><P>Anyone has an idea how to fix that please?</P></BODY></HTML> Thu, 16 Jan 2014 16:34:12 GMT https://community.qlik.com/t5/QlikView/help-with-a-SLA-calculation/m-p/523921#M195700 rcandeo 2014-01-16T16:34:12Z Re: help with a SLA calculation https://community.qlik.com/t5/QlikView/help-with-a-SLA-calculation/m-p/523922#M195701 <HTML><HEAD></HEAD><BODY><P>See this discussion: <A href="https://community.qlik.com/message/276455">Re: Working hours only</A></P></BODY></HTML> Thu, 16 Jan 2014 18:33:52 GMT https://community.qlik.com/t5/QlikView/help-with-a-SLA-calculation/m-p/523922#M195701 Gysbert_Wassenaar 2014-01-16T18:33:52Z Re: help with a SLA calculation https://community.qlik.com/t5/QlikView/help-with-a-SLA-calculation/m-p/523923#M195702 <HTML><HEAD></HEAD><BODY><P>See attached.</P><P>I didn't use your SLA calculation, although kept it in the script.&nbsp; Added a little more script to calculate "legal" Start and End time.</P></BODY></HTML> Thu, 16 Jan 2014 20:36:02 GMT https://community.qlik.com/t5/QlikView/help-with-a-SLA-calculation/m-p/523923#M195702 Anonymous 2014-01-16T20:36:02Z Re: Re: help with a SLA calculation https://community.qlik.com/t5/QlikView/help-with-a-SLA-calculation/m-p/523924#M195703 <HTML><HEAD></HEAD><BODY><P>Hi, Thank You very much, but almost there. If you put 10/01/2014 18:30:00 as start time and 13/01/2014 08:40 as end time, the SLA that should be 40 minutes but appears as 10 minutes.</P><P>Can you help me again? The qvw with this new date is attached.</P></BODY></HTML> Fri, 17 Jan 2014 03:05:35 GMT https://community.qlik.com/t5/QlikView/help-with-a-SLA-calculation/m-p/523924#M195703 rcandeo 2014-01-17T03:05:35Z Re: Re: Re: help with a SLA calculation https://community.qlik.com/t5/QlikView/help-with-a-SLA-calculation/m-p/523925#M195704 <HTML><HEAD></HEAD><BODY><P>See attached qvw. I added some fields only so I could simply copy+paste <A _jive_internal="true" data-avatarid="5408" data-externalid="" data-online="false" data-presence="null" data-userid="15823" data-username="swuehl" href="https://community.qlik.com/people/swuehl" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7; text-decoration: underline;">swuehl</A>'s expression as is. </P></BODY></HTML> Fri, 17 Jan 2014 06:50:08 GMT https://community.qlik.com/t5/QlikView/help-with-a-SLA-calculation/m-p/523925#M195704 Gysbert_Wassenaar 2014-01-17T06:50:08Z Re: Re: help with a SLA calculation https://community.qlik.com/t5/QlikView/help-with-a-SLA-calculation/m-p/523926#M195705 <HTML><HEAD></HEAD><BODY><P>Thank You Very Much for helping me!</P></BODY></HTML> Fri, 17 Jan 2014 12:54:56 GMT https://community.qlik.com/t5/QlikView/help-with-a-SLA-calculation/m-p/523926#M195705 rcandeo 2014-01-17T12:54:56Z Re: Re: Re: help with a SLA calculation https://community.qlik.com/t5/QlikView/help-with-a-SLA-calculation/m-p/523927#M195706 <HTML><HEAD></HEAD><BODY><P>Although it's resolved, I wanted to find out and to fix the problem.&nbsp; My previous solution didn't take into account initial time after 18 and end time before 8.&nbsp; Fixed in the new attached.</P></BODY></HTML> Fri, 17 Jan 2014 14:55:05 GMT https://community.qlik.com/t5/QlikView/help-with-a-SLA-calculation/m-p/523927#M195706 Anonymous 2014-01-17T14:55:05Z Re: help with a SLA calculation https://community.qlik.com/t5/QlikView/help-with-a-SLA-calculation/m-p/523928#M195707 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P>I need some help and I am unable to start a new thread therefore I am using this as my issue is linked with an SLA calculation problem.</P><P></P><P>I would like to calculate the SLA of all incidents that have not been modified in the last 3 days.</P><P>SLA metric: &gt;90%</P><P>Fields: Last Modified, Reference number</P><P></P><P>Anyone can advise with an expression to calculate it in chart and show as percentage?</P><P></P><P>Thank you in advance.</P><P>Kind regards</P><P>N.</P></BODY></HTML> Mon, 02 Feb 2015 17:07:09 GMT https://community.qlik.com/t5/QlikView/help-with-a-SLA-calculation/m-p/523928#M195707 2908nmadao 2015-02-02T17:07:09Z