topic Re: Null Values in QlikView

Null Values

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

I am importing data from a SQL Server table. The table has 426 records as follows:

There are no null values in the table above.

However when the table records are imported into a QV straight table, it contains some null values as follows:

What could be going on? Please assist.

Regards

Re: Null Values

vishsaggi — Mon, 19 Feb 2018 04:47:54 GMT

How you are importing data from SQL server are you running a Select statement using SQL Select or from a text file?

Re: Null Values

jonathandienst — Mon, 19 Feb 2018 04:55:24 GMT

Is [Port Loading Date] a key field? In other words, does the field name exist in more than one table?

Re: Null Values

Anonymous — Mon, 19 Feb 2018 10:44:57 GMT

I am using SQL Select as follows:

My table view is as follows;

Thank you

Re: Null Values

Anonymous — Mon, 19 Feb 2018 10:47:57 GMT

Thanks Jonathan. My table view is as follows:

The field [Port Loading Calendar] exists in the main table (IndiaImports) and the calendar.

My SQL Select statement for import of data is as follows:

Regards

Re: Null Values

jonathandienst — Wed, 21 Feb 2018 05:51:22 GMT

The table ImportPortLoadingCalendar contains values of portLoadingDate which are not in IndiaImports. Those dates will have nulls for all the values not present in IndiaImports.

Re: Null Values

Anonymous — Fri, 23 Feb 2018 08:46:22 GMT

Thanks Jonathan, that is the cause of the null values. Managed to change everything to make it work