topic Re: Data not appearing in Table box in QlikView

Data not appearing in Table box

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

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

Re: Data not appearing in Table box

avkeep01 — Tue, 11 Dec 2018 11:11:12 GMT

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.

Re: Data not appearing in Table box

sagar_vij99 — Tue, 11 Dec 2018 11:12:15 GMT

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

Re: Data not appearing in Table box

avkeep01 — Tue, 11 Dec 2018 11:15:01 GMT

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.

Re: Data not appearing in Table box

jonathandienst — Tue, 11 Dec 2018 11:15:45 GMT

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.

Re: Data not appearing in Table box

sagar_vij99 — Tue, 11 Dec 2018 11:16:55 GMT

Both are table box.

Re: Data not appearing in Table box

Gysbert_Wassenaar — Tue, 11 Dec 2018 11:17:42 GMT

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

Re: Data not appearing in Table box

tresB — Tue, 11 Dec 2018 11:19:31 GMT

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