topic Re: IsNull not showing the result I require in QlikView

IsNull not showing the result I require

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

Hi,

I have the attached Document.

I have a field called IsItMissing which I was expecting a value of 1 for the IdNo 3?

Any ideas as to why?

Thanks

Re: IsNull not showing the result I require

swuehl — Tue, 21 Mar 2017 10:19:36 GMT

The field value is only NULL in your resulting table after the JOIN, not when you are LOADing your second inline table.

You would need to do the check in a resident load of your resulting table to check for a NULL in the JOIN'ed tables.

Re: IsNull not showing the result I require

Peter_Cammaert — Tue, 21 Mar 2017 10:21:33 GMT

Yes.

You create a field IsItMissing while loading rows from the second table. All areas in that table are present. ONLY THEN are you performing a LEFT JOIN to a table where the new records may have NULL values in Area. That's too late for IsItMissing.

Solution: add an additional step to reload the JOINed table into a new one, and create IsItMissing in that LOAD statement.

Re: IsNull not showing the result I require

ivandrago — Tue, 21 Mar 2017 10:25:27 GMT

Hi,

How would I do the additional step? Would you be able to show as I do not understand?

Thanks

Re: IsNull not showing the result I require

Peter_Cammaert — Tue, 21 Mar 2017 10:29:52 GMT

See the attachment to my previous post.

Best,

Peter

Re: IsNull not showing the result I require

qlik_jaijhn — Tue, 21 Mar 2017 10:35:59 GMT

Hi,

You need to have a resident load after the left join and there we need to add the field. Please check the attached file.

Thanks, Jai