Welcome back to QlikShare.Com. I’m posting after long time and hopefully I’ll continue to make more video tutorials.

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!)

——————————————————————————————

Here is the sample script for your reference:

Map_Nulls:
Mapping LOAD
NULL(),
‘<Unknown>’
AutoGenerate 1;

MAP FieldName, * using Map_Nulls;

——————————————————————————————

I’d recommend you to partcipate in QQotD (QlikView Question of the Day). Quick knowledge check and hopefully something new to learn… here is the link :

http://QlikShare.com/qotd

Thank you for watching. Happy learning.