Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)