Data not appearing in Table box

[sagar_vij99]

Hi All,

I am making a dashboard in which i am simply importing a table from Excel File. I made chart to show count of records.

Now chart is showing correct number of records for selections made but table box is not showing all records. Next i did is created another table box and the second box is showing all relevant data.

Can anyone tell me why this is happening..?? See the screenshot.

Regards

Sagar

[avkeep01]

Hi Sagar, 

You probably checked "Omit rows where field value is NULL" on the presentation sheet in the settings of the table box for one of the fields in the table box. 

[sagar_vij99]

I have checked already, that's not the case. And i have unique records also.

[avkeep01]

Is the second object (with the blue header) in your printscreen the table box you're refering to? Is it a chart or a table box. Can't see it, but if it is a chart, then you'll need probally an expression. 

Can you upload a sample .qvw if possible? that gives more information. 

[jonathandienst]

A table box only shows distinct rows with the selected fields, so if two rows have the same values in all included fields, they will show as one row not two.

A table box is not a good way to look at this data. Rather use a straight table where you can include a count expression. and you can include a total.

Or during the load, add a unique row number and include that in the box.

[sagar_vij99]

Both are table box.

[Gysbert_Wassenaar]

A table box will never show duplicate records. If you want to show duplicate records as well then when you load the data you will have to create a field that has a unique value for each record. The RowNo() function can be used for this:

LOAD
    ...lots of fields... ,
    RowNo() as RecordID
FROM
    ...source table...;

When you've created that RecordID field and reloaded the data you can add the new field to the table box so that all records will show even if they are duplicates

[tresesco]

Table box shows only the unique combinations of field values. If you need to show all the records, try using straight table instead.