Check no of rows and size of data load to dashboard

[#1]

Dear community,

May I know how to check the number of rows and size of data load to dashboard by looking at log file in server?

Normally we can get this information when loading the dashboard at desktop, but my current case is that dashboard is scheduled to auto reload in server, so i am unable to trace to number of rows and size of data that dashboard has fetched from database server.

Thanks,

Chanel

[#2 · Accepted solution]

This should be in your log file in the same folder as your qlikview file. Make sure Generate logfile option is selected in your document properties.

[Anonymous]

Hi,

"i am unable to trace to number of rows and size of data that dashboard has fetched from database server." Do you mean, you don't have access on dashboard on the server?

There are functions in qlikview which can give you the actual size of table and no of rows in the table. For example, you may check below function,

FileSize()

RowNo()

We also have system fields "$Rows" where you can see the no of rows available in each table.

[#4]

For adhoc investigations have this expression in a list box

=$Table  & ' : ' & $Rows

[#5]

Thanks for all your reply!

I have the log file with Ramkumar's suggestion and found that currently there is 3mil rows in my document!

Best regards,

Chanel