topic Re: count value from database in App Development https://community.qlik.com/t5/App-Development/count-value-from-database/m-p/1318497#M28393 <HTML><HEAD></HEAD><BODY><P>May be this</P><P><STRONG>Count({&lt;Country = {'Germany'}&gt;}Country)</STRONG></P></BODY></HTML> Mon, 31 Jul 2017 12:05:34 GMT sunny_talwar 2017-07-31T12:05:34Z count value from database https://community.qlik.com/t5/App-Development/count-value-from-database/m-p/1318496#M28392 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have this table imported <SPAN class="short_text" lang="en"><SPAN>from the database:</SPAN></SPAN></P><TABLE border="1" class="jiveBorder" height="125" style="border: 1px solid rgb(0, 0, 0); width: 284px; height: 102px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Country</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Value</TH></TR><TR><TD style="padding: 2px;">Germany</TD><TD style="padding: 2px;">20</TD></TR><TR><TD style="padding: 2px;">Turkey</TD><TD style="padding: 2px;">10</TD></TR><TR><TD style="padding: 2px;">Austria</TD><TD style="padding: 2px;">30</TD></TR><TR><TD style="padding: 2px;">Germany</TD><TD style="padding: 2px;">10</TD></TR></TBODY></TABLE><P></P><P><SPAN class="short_text" lang="en"><SPAN>I want to make a KPI chart <SPAN class="short_text" lang="en"><SPAN>that counts countries</SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN><SPAN class="short_text" lang="en"><SPAN>Germany = 2</SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN><SPAN class="short_text" lang="en"><SPAN><BR /></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN><SPAN class="short_text" lang="en"><SPAN>Thank you!</SPAN></SPAN><BR /></SPAN></SPAN></P></BODY></HTML> Wed, 22 Dec 2021 15:42:54 GMT https://community.qlik.com/t5/App-Development/count-value-from-database/m-p/1318496#M28392 2021-12-22T15:42:54Z Re: count value from database https://community.qlik.com/t5/App-Development/count-value-from-database/m-p/1318497#M28393 <HTML><HEAD></HEAD><BODY><P>May be this</P><P><STRONG>Count({&lt;Country = {'Germany'}&gt;}Country)</STRONG></P></BODY></HTML> Mon, 31 Jul 2017 12:05:34 GMT https://community.qlik.com/t5/App-Development/count-value-from-database/m-p/1318497#M28393 sunny_talwar 2017-07-31T12:05:34Z