topic Re: Table box count not matching with database in QlikView

Table box count not matching with database

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a table box that displays record details for the given field selections. When I exported the dataset directly from

the table box (Excel icon in upper right), the Excel shows 89 rows. When I run my SQL query against the source

table in SQL Server, I get a count of 219. The 219 is correct. I looked through the table box settings and I didn't see anything

which would restrict the number of rows being returned.

Anyone knows why I'm seeing this discrepancy?

Thanks!

swuehl — Wed, 28 Sep 2016 19:57:39 GMT

The table box only shows distinct rows, you would need to add e.g. a RecID or something that makes your rows unique to compare with the SQL query.

LOAD *,

RecNo() as RecID

FROM YourTableSource;

Anonymous — Wed, 28 Sep 2016 20:05:54 GMT

Wow! That was it. I didn't know that. Thank you!!

swuehl — Wed, 28 Sep 2016 20:19:15 GMT

Probably Qlik should better not have named this chart object 'table box' a long time ago...

If your issue is resolved, then please close this thread by marking helpful and / or correct answers:

Anonymous — Wed, 28 Sep 2016 21:46:01 GMT

Agreed. Or perhaps provide a setting to allow unique or non-unique rows to be displayed.