Solved: Re: Table box count not matching with database - Qlik Community

Anonymous · ‎2016-09-28

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 · ‎2016-09-28

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;

swuehl · ‎2016-09-28

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 · ‎2016-09-28

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

swuehl · ‎2016-09-28

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 · ‎2016-09-28

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