topic Re: Getting null values while joining tables in QlikView

Getting null values while joining tables

Sumit2504 — Tue, 23 Nov 2021 03:24:43 GMT

Hi All,

I've two tables.

1st table Contains two fields, Bill number and Bill category.

2 table is fact table containing Bill number and Document number

while joining table 1 and fact with Bill number. I am getting null records when using Document number and bill number in a table box.

My requirement - Convert null records into values so that there's always a bill number for every document number.

Can anyone please help here.

Re: Getting null values while joining tables

abhijitnalekar — Tue, 23 Nov 2021 05:08:50 GMT

Hi @Sumit2504,

I would suggest using apply map functionality to get the document number.

With the apply map you can also set the default value which is not present into the respective table.

Also share the data if possible so I can show the example.

Re: Getting null values while joining tables

Gusikowski — Wed, 24 Nov 2021 06:18:45 GMT

As we have seen from the above examples joining NULL values does not work. Even though you have two NULL values SQL Server does not treat these as the same value. Internally a value of NULL is an unknown value and therefore SQL Server does not equate an unknown value being equal to another unknown value.

Liteblue