Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
If you have a primary key, you can put the number of records in the caption:
='Number of records: ' & count(PrimaryKey)
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.
"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.