topic Row count for table box? in QlikView

Row count for table box?

Wed, 25 Nov 2020 16:16:04 GMT

I am completely new to QlikView (got it installed today)... How do I add a row/record count to my table box? I want it to show the total row count (i.e. 80 records) at the bottom of the box if possible. Even better would be as I apply filters, the count would change (i.e. 14 of 80 records). There are currently no primary keys defined. I appreciate any help offered.

Re: Row count for table box?

m_woolf — Thu, 16 Jun 2016 15:29:45 GMT

If you have a primary key, you can put the number of records in the caption:

='Number of records: ' & count(PrimaryKey)

Re: Row count for table box?

rubenmarin — Thu, 16 Jun 2016 15:41:45 GMT

As m w points, you'll need a primary key to count rows, if a table box finds some rows with identical data in all columns, it will only show one row, but the Count() will count all the records, so number of records can be different to the numbers of rows in the table box.

If this doesn't matter, the 2nd part of the sentence can be formed like:

='Number of records: ' & count(FieldName) & ' of ' & count({1} FieldName)

Or you can change to an straight table chart, adding your current fields of the table as Dimensions, and with the expression:

RowNo()

Edit: I forgot you want this in a single line, not a count by row.

Re: Row count for table box?

fd — Thu, 09 Apr 2020 09:31:59 GMT

"here are currently no primary keys defined"

if you do not have any unique field, then you can make yours like this; Count(Field1&'-'&Field2&'-'&Field3)

These fields are the dimension fields of your table object.