topic Expression in KPI in App Development https://community.qlik.com/t5/App-Development/Expression-in-KPI/m-p/1051955#M16591 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I want to ask why i keep getting negative value when using expression <STRONG style="color: #ff6600;">Sum(status='fail'). </STRONG></P><P><SPAN style="color: #000000;">Here are the attachment for the expression that i use.</SPAN></P><P></P><P>The total should be in positive value because i want to count the total in subject english and science.</P><P><IMG alt="2016-04-05 11_42_25-a - My new sheet _ App overview - Qlik Sense.png" class="jive-image image-1" src="/legacyfs/online/120465_2016-04-05 11_42_25-a - My new sheet _ App overview - Qlik Sense.png" style="height: auto;" /><IMG alt="2016-04-05 11_42_55-Subject - Excel.png" class="jive-image image-2" height="226" src="/legacyfs/online/120466_2016-04-05 11_42_55-Subject - Excel.png" style="height: 226.145px; width: 237px;" width="237" /></P></BODY></HTML> Tue, 05 Apr 2016 03:52:05 GMT 2016-04-05T03:52:05Z Expression in KPI https://community.qlik.com/t5/App-Development/Expression-in-KPI/m-p/1051955#M16591 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I want to ask why i keep getting negative value when using expression <STRONG style="color: #ff6600;">Sum(status='fail'). </STRONG></P><P><SPAN style="color: #000000;">Here are the attachment for the expression that i use.</SPAN></P><P></P><P>The total should be in positive value because i want to count the total in subject english and science.</P><P><IMG alt="2016-04-05 11_42_25-a - My new sheet _ App overview - Qlik Sense.png" class="jive-image image-1" src="/legacyfs/online/120465_2016-04-05 11_42_25-a - My new sheet _ App overview - Qlik Sense.png" style="height: auto;" /><IMG alt="2016-04-05 11_42_55-Subject - Excel.png" class="jive-image image-2" height="226" src="/legacyfs/online/120466_2016-04-05 11_42_55-Subject - Excel.png" style="height: 226.145px; width: 237px;" width="237" /></P></BODY></HTML> Tue, 05 Apr 2016 03:52:05 GMT https://community.qlik.com/t5/App-Development/Expression-in-KPI/m-p/1051955#M16591 2016-04-05T03:52:05Z Re: Expression in KPI https://community.qlik.com/t5/App-Development/Expression-in-KPI/m-p/1051956#M16592 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Count({&lt;Status = {'fail'}&gt;} status)</STRONG></P></BODY></HTML> Tue, 05 Apr 2016 15:35:38 GMT https://community.qlik.com/t5/App-Development/Expression-in-KPI/m-p/1051956#M16592 sunny_talwar 2016-04-05T15:35:38Z Re: Expression in KPI https://community.qlik.com/t5/App-Development/Expression-in-KPI/m-p/1051957#M16593 <HTML><HEAD></HEAD><BODY><P>Tq for your help.. </P></BODY></HTML> Wed, 06 Apr 2016 01:48:23 GMT https://community.qlik.com/t5/App-Development/Expression-in-KPI/m-p/1051957#M16593 2016-04-06T01:48:23Z