how to display the count of rows in the subtitle of a table

[daveatkins]

This is more a debugging and validation item but it comes up so often...

I have a straight table and as users select various filters, I want to show how many rows are being selected in the table. (The purpose of the table is to create a data extract so the user can download to excel.) There are often data issues with duplicates, etc. so what I want in the subtitle is just:

='displaying ' & count(distinct AccountNumber) & ' accounts, '  &  count(AccountNumber) & ' total rows'

what happens, however is I get numbers like

displaying 410 accounts, 4896 total rows

and when saved to excel, there are 428 rows in the spreadsheet

so that 4896 number is like the internal count of something that qlik has "helpfully" reduced, but what I really need is to know how many rows are being displayed. I tried adding

& NoOfRows(TOTAL)

but this evaluates to 1

[Kushal_Chawda]

What is your measures in your straight table? You may need to include conditions  of your measures as well to get correct row

For example, if you have measure sum({<Flag={1}>}Sales) you can write below expression for total rows

count({<Flag={1}>}AccountNumber)