topic Re: Load gives Null in Table but qlik sense actually loads the all rows in App Development

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

rpavan17 — Sat, 16 Nov 2024 06:42:55 GMT

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

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

rpavan17 — Thu, 31 Jan 2019 06:44:31 GMT

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

pradosh_thakur — Thu, 31 Jan 2019 07:05:10 GMT

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

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

rpavan17 — Thu, 31 Jan 2019 07:27:35 GMT

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

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

pradosh_thakur — Thu, 31 Jan 2019 07:59:47 GMT

What is the information density?

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

rpavan17 — Thu, 31 Jan 2019 08:10:38 GMT

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

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

pradosh_thakur — Thu, 31 Jan 2019 08:32:46 GMT

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.