topic How to use count function in QlikView https://community.qlik.com/t5/QlikView/How-to-use-count-function/m-p/235891#M87120 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have the following case:</P><P>Table structure:</P><P>Category</P><P>A</P><P>A</P><P>B</P><P>I want to get the row count whose category is A, it results will be 2.</P><P>How can I do?</P><P>Thanks.</P><P></P><P>Isaac Li</P><P></P></BODY></HTML> Wed, 13 Oct 2010 08:02:39 GMT 2010-10-13T08:02:39Z How to use count function https://community.qlik.com/t5/QlikView/How-to-use-count-function/m-p/235891#M87120 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have the following case:</P><P>Table structure:</P><P>Category</P><P>A</P><P>A</P><P>B</P><P>I want to get the row count whose category is A, it results will be 2.</P><P>How can I do?</P><P>Thanks.</P><P></P><P>Isaac Li</P><P></P></BODY></HTML> Wed, 13 Oct 2010 08:02:39 GMT https://community.qlik.com/t5/QlikView/How-to-use-count-function/m-p/235891#M87120 2010-10-13T08:02:39Z How to use count function https://community.qlik.com/t5/QlikView/How-to-use-count-function/m-p/235892#M87121 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>1. If you are using a straight table then just put Category in dimension and in expression specify</P><P>count(Category)</P><P>2. If you are using a text object then you can write the following expression</P><P>count(if(Category='A',Category))</P><P></P><P>May be this helps you.</P><P></P><P>Thanks &amp; Best Regards</P><P>Kuldeep Tak</P></BODY></HTML> Wed, 13 Oct 2010 08:08:08 GMT https://community.qlik.com/t5/QlikView/How-to-use-count-function/m-p/235892#M87121 2010-10-13T08:08:08Z