Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to log the number of records in each resident table?

I have a log file associated to my qvw but I'd like to also log how many records each resident table has when I reload the file. Any idea how to do this?

1 Solution

Accepted Solutions
martin59
Specialist II
Specialist II

Hello Igor,

If you stock the number of records into a variable, you could see that value using the debogger mode.

The function is NoOfRows(TableName).

Martin

View solution in original post

3 Replies
martin59
Specialist II
Specialist II

Hello Igor,

If you stock the number of records into a variable, you could see that value using the debogger mode.

The function is NoOfRows(TableName).

Martin

Not applicable
Author

I will try that, thanks.

Not applicable
Author

Hello, Igor,

Here is the example:

let vtext = '---------------------->>>Orders Count: ' & num(NoOfRows('TableName'), '#,##0');
trace $(vtext);
TRACE --->> Loading;