topic Qlikview Expression -Performance Indicator in QlikView https://community.qlik.com/t5/QlikView/Qlikview-Expression-Performance-Indicator/m-p/908782#M315590 <HTML><HEAD></HEAD><BODY><P><IMG alt="quww.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/94828_quww.PNG" style="height: auto;" /></P><P></P><P>Hello All,</P><P></P><P>I have set up a health indicator for various divisions for the SLA performance. The expression I have used is :</P><P></P><P><SPAN style="font-size: 8pt;">({ &lt; </SPAN><SPAN style="color: #800000; font-size: 8pt;">SLA.Stage</SPAN><SPAN style="font-size: 8pt;">={Achieved}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">SLA.Counter</SPAN><SPAN style="font-size: 8pt;">) / <BR /><BR /></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">({ &lt; </SPAN><SPAN style="color: #800000; font-size: 8pt;">SLA.Stage</SPAN><SPAN style="font-size: 8pt;">={Breached, Achieved}&gt;} </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Total</SPAN><SPAN style="font-size: 8pt;"> &lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Group Name]</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">SLA.TicketType</SPAN><SPAN style="font-size: 8pt;">&gt; </SPAN><SPAN style="color: #800000; font-size: 8pt;">SLA.Counter</SPAN><SPAN style="font-size: 8pt;">) * 1000</SPAN></P><P> </P><P> </P><P><SPAN style="font-size: 8pt;">Is this correct to display SLA information. I am not sure of this formula, so need you're valuable suggestions</SPAN></P><P></P><P><BR /> </P></BODY></HTML> Mon, 03 Aug 2015 18:22:37 GMT 2015-08-03T18:22:37Z Qlikview Expression -Performance Indicator https://community.qlik.com/t5/QlikView/Qlikview-Expression-Performance-Indicator/m-p/908782#M315590 <HTML><HEAD></HEAD><BODY><P><IMG alt="quww.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/94828_quww.PNG" style="height: auto;" /></P><P></P><P>Hello All,</P><P></P><P>I have set up a health indicator for various divisions for the SLA performance. The expression I have used is :</P><P></P><P><SPAN style="font-size: 8pt;">({ &lt; </SPAN><SPAN style="color: #800000; font-size: 8pt;">SLA.Stage</SPAN><SPAN style="font-size: 8pt;">={Achieved}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">SLA.Counter</SPAN><SPAN style="font-size: 8pt;">) / <BR /><BR /></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">({ &lt; </SPAN><SPAN style="color: #800000; font-size: 8pt;">SLA.Stage</SPAN><SPAN style="font-size: 8pt;">={Breached, Achieved}&gt;} </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Total</SPAN><SPAN style="font-size: 8pt;"> &lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Group Name]</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">SLA.TicketType</SPAN><SPAN style="font-size: 8pt;">&gt; </SPAN><SPAN style="color: #800000; font-size: 8pt;">SLA.Counter</SPAN><SPAN style="font-size: 8pt;">) * 1000</SPAN></P><P> </P><P> </P><P><SPAN style="font-size: 8pt;">Is this correct to display SLA information. I am not sure of this formula, so need you're valuable suggestions</SPAN></P><P></P><P><BR /> </P></BODY></HTML> Mon, 03 Aug 2015 18:22:37 GMT https://community.qlik.com/t5/QlikView/Qlikview-Expression-Performance-Indicator/m-p/908782#M315590 2015-08-03T18:22:37Z