Load gives Null in Table but qlik sense actually loads the all rows

[rpavan17]

Hi,

I am loading data from Oracle DB. In the load it shows 40,000 lines loaded. It contains 5 fields.

In Table Object i can see 40,000 lines but  8000 lines does not contain 2 fields data and rest of 3 fields contains data.

Please see screenshot

[rpavan17]

[pradosh_thakur]

What is the information density of the columns in the data model ? Can you please check and confirm?

[rpavan17]

There is no limit in reading lines in data model. It suppose to read all lines. 

[pradosh_thakur]

What is the information density?

[rpavan17]

84% with Value fields and 16% are non value fields. Is this you are looking for?

[pradosh_thakur]

In the data model when you click on the field and table, you can see the details like information density, subset ratio , unique values etc. It will tell us if the values are fetched as null form the data base . So you can cross check if that is the case by counting the null in database as well in QLIK.