Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sagar_vij99
Creator
Creator

Data not appearing in Table box

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

7 Replies
avkeep01
Partner
Partner

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
Creator
Creator
Author

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

avkeep01
Partner
Partner

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
Partner
Partner

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
sagar_vij99
Creator
Creator
Author

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


talk is cheap, supply exceeds demand
tresesco
MVP
MVP

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