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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
surajap123
Creator III
Creator III

no. of rows?

Hi,

I want to calculate size of the data in my dashboard.

I have 3 large tables in the data model and the number of rows are below-

31134514

2235416

51561


While talking about no. of rows in my dashboard, do i need to consider only the rows in the biggest table or sum of rows in all the tables?

3 Replies
its_anandrjs
Champion III
Champion III

You can use filesize( ) function to calculate the file size of the tables and store it in any table for calculation.

Not applicable

If you're talking about rows in your dashboard, I'd assume it would be the sum of all rows in all the tables

Anonymous
Not applicable

Number of rows and size of the data are tow different things.  Row can be a few (or just one) short numeric columns or many columns with long text.  Your application (qvw) size, not compressed, maybe a better indicator of the data size.