topic displaying count on the table box title in QlikView https://community.qlik.com/t5/QlikView/displaying-count-on-the-table-box-title/m-p/364636#M135658 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is it possible to display the count of total no. of rows in a table on the title?</P><P></P><P>I cannot use count(field1) for e.g. to display the count as it will just give the count of field1. I am looking for the count for the actual rows created.</P></BODY></HTML> Thu, 22 Mar 2012 13:05:02 GMT 2012-03-22T13:05:02Z displaying count on the table box title https://community.qlik.com/t5/QlikView/displaying-count-on-the-table-box-title/m-p/364636#M135658 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is it possible to display the count of total no. of rows in a table on the title?</P><P></P><P>I cannot use count(field1) for e.g. to display the count as it will just give the count of field1. I am looking for the count for the actual rows created.</P></BODY></HTML> Thu, 22 Mar 2012 13:05:02 GMT https://community.qlik.com/t5/QlikView/displaying-count-on-the-table-box-title/m-p/364636#M135658 2012-03-22T13:05:02Z displaying count on the table box title https://community.qlik.com/t5/QlikView/displaying-count-on-the-table-box-title/m-p/364637#M135659 <HTML><HEAD></HEAD><BODY><P>Count( field1 ) will indeed show the total count of records in the table - well, except for the records where field1 is NULL. </P><P></P><P>So if you use an expression</P><P>=Count( field1 ) + NullCount( field1 ) </P><P>then you will have the number of records.</P><P></P><P>/HIC</P></BODY></HTML> Thu, 22 Mar 2012 13:50:07 GMT https://community.qlik.com/t5/QlikView/displaying-count-on-the-table-box-title/m-p/364637#M135659 hic 2012-03-22T13:50:07Z