topic Re: no. of rows? in QlikView

no. of rows?

surajap123 — Tue, 10 Jun 2014 15:04:07 GMT

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?

Re: no. of rows?

its_anandrjs — Tue, 10 Jun 2014 15:19:41 GMT

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

Re: no. of rows?

Tue, 10 Jun 2014 20:26:52 GMT

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

Re: no. of rows?

Anonymous — Tue, 10 Jun 2014 20:47:07 GMT

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.