How to remove NULL values by Mapping Load & Map Using statements...

Subscribers : Thanks for the subscription to my channel but I encourage you to use my blog to watch the videos. Some of the videos are not available on YouTube or I have made private video tutorials which are only availabe on my blog.

In this video, I'll show you how to remove NULL values by Mapping Load & Map Using statements. As you know, NULL values are always an issue of concern while building QlikView applications. You'll be happy to know that QlikView handles NULLs in Three-Valued-Logic. There is excellent white paper on how QlikView handles NULLs and this is written by Henric Cronström (Many thanks HIC!)

Thank you for watching. Happy learning.

[KayYesYouTuber]

Thank you. This was extremely useful to me.

[cvalarcon]

Thank you again for your clear explanation

[nrucuiw]

In script you have used Autogenerate 1. So how can we see these autogenerated numbers in front end.

[mcnater]

Can you use a preceding load instead of Resident? Does it still work? I haven't tried it yet.

[archanakulkarni]

Hi, In my report i am using straight table and last row having 0 after joing tables i need to make it as Unknown or with some other value. Please help me

[amandasundberg]

Hi, what about if I want to use a mapping table from excel? Qlik does not seem to want to map my empty value in the excel document, but maps all other values.

[priscilla]

Hi
This is what i needed butmy lis box is still giving me nulls, i am using spread sheet
See the script

Map_Nulls:
Mapping Load
Null(),
'<Not Submitted>'
AutoGenerate 1;
MAP [Candidate FullName], [CV Send Date]
using Map_Nulls;

CV:
LOAD
if(len( [Candidate FullName])=0, Null(), [Candidate FullName]) as [Submited CV],
if(len( [CV Send Date])=0, Null(), [CV Send Date]) as [CV Send Date]


Resident ZAK_RECRUTMENT
Thanking you in advance