topic How to start calculate & display KPIs like Installation Rate in QlikView https://community.qlik.com/t5/QlikView/How-to-start-calculate-display-KPIs-like-Installation-Rate/m-p/342349#M1168008 <HTML><HEAD></HEAD><BODY><P>Hello,<BR />please, i need some help because i'm a beginner.</P><P><BR />So my data model look like this:</P><P><BR />- Order_id<BR />- Order_status [Finalized / Canceled / WIP / Non-validated]</P><P><BR />I want to calculate and display in a gauge chart let's say the<STRONG> Installation Rate KPI: A</STRONG>mount of orders with Order_status = 'Finalized' / Total amount of orders excluding orders with order_status='Non-validated'</P><P></P><P></P><P>Regards,</P><P>Mihai</P></BODY></HTML> Tue, 07 Aug 2012 13:26:31 GMT bvmike2001 2012-08-07T13:26:31Z How to start calculate & display KPIs like Installation Rate https://community.qlik.com/t5/QlikView/How-to-start-calculate-display-KPIs-like-Installation-Rate/m-p/342349#M1168008 <HTML><HEAD></HEAD><BODY><P>Hello,<BR />please, i need some help because i'm a beginner.</P><P><BR />So my data model look like this:</P><P><BR />- Order_id<BR />- Order_status [Finalized / Canceled / WIP / Non-validated]</P><P><BR />I want to calculate and display in a gauge chart let's say the<STRONG> Installation Rate KPI: A</STRONG>mount of orders with Order_status = 'Finalized' / Total amount of orders excluding orders with order_status='Non-validated'</P><P></P><P></P><P>Regards,</P><P>Mihai</P></BODY></HTML> Tue, 07 Aug 2012 13:26:31 GMT https://community.qlik.com/t5/QlikView/How-to-start-calculate-display-KPIs-like-Installation-Rate/m-p/342349#M1168008 bvmike2001 2012-08-07T13:26:31Z Re: How to start calculate & display KPIs like Installation Rate https://community.qlik.com/t5/QlikView/How-to-start-calculate-display-KPIs-like-Installation-Rate/m-p/342350#M1168009 <HTML><HEAD></HEAD><BODY><P>please see attached example :</P><P>F1: order_id</P><P>F2: order_status</P></BODY></HTML> Tue, 07 Aug 2012 13:35:44 GMT https://community.qlik.com/t5/QlikView/How-to-start-calculate-display-KPIs-like-Installation-Rate/m-p/342350#M1168009 giakoum 2012-08-07T13:35:44Z Re: How to start calculate & display KPIs like Installation Rate https://community.qlik.com/t5/QlikView/How-to-start-calculate-display-KPIs-like-Installation-Rate/m-p/342351#M1168010 <HTML><HEAD></HEAD><BODY><P>Many thanks Ioannis!</P><P></P><P>And how to exclude from the Total amount of orders the orders with Order_status=Unvalidated?</P></BODY></HTML> Tue, 07 Aug 2012 13:53:58 GMT https://community.qlik.com/t5/QlikView/How-to-start-calculate-display-KPIs-like-Installation-Rate/m-p/342351#M1168010 bvmike2001 2012-08-07T13:53:58Z Re: How to start calculate & display KPIs like Installation Rate https://community.qlik.com/t5/QlikView/How-to-start-calculate-display-KPIs-like-Installation-Rate/m-p/342352#M1168011 <HTML><HEAD></HEAD><BODY><P>Count({$&lt;[F2]={"Finalized"}&gt;} F1) / Count({$&lt;[F2] -= {"Non-validated"}&gt;} F1)</P></BODY></HTML> Tue, 07 Aug 2012 14:09:50 GMT https://community.qlik.com/t5/QlikView/How-to-start-calculate-display-KPIs-like-Installation-Rate/m-p/342352#M1168011 giakoum 2012-08-07T14:09:50Z