Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
mwoolf
Honored Contributor II

Table Viewer number of rows discrepancy?

When I look at a table in the table viewer, it says it has 733,248 rows.

When I make a table box for the same table, the table box shows 733,290 rows.

Has anyone else seen this behavior? Is this a problem with the table viewer?

1 Solution

Accepted Solutions
mwoolf
Honored Contributor II

Re: Table Viewer number of rows discrepancy?

I did another test.

Table viewer says: 602,479

Table box says: 850,882

If I remove the key field from the table box, it says: 602,399

Looks like the table box is showing rows for the key fields where the data exists in the related table. 

 

 

View solution in original post

4 Replies

Re: Table Viewer number of rows discrepancy?

Can you possibly added another field from another table into your table box? This field can be from a table where you had one to many relationship.

mwoolf
Honored Contributor II

Re: Table Viewer number of rows discrepancy?

I did another test.

Table viewer says: 602,479

Table box says: 850,882

If I remove the key field from the table box, it says: 602,399

Looks like the table box is showing rows for the key fields where the data exists in the related table. 

 

 

View solution in original post

Re: Table Viewer number of rows discrepancy?

I believe that is exactly what is going on. May be pick a non key field which cannot have a null value and for that field check 'Omit Rows Where Field is NULL' on the presentation tab of the table box properties.

mwoolf
Honored Contributor II

Re: Table Viewer number of rows discrepancy?

Sunny - I tried to "Like" your response, but it doesn't seem to work. Thanks for your help.