topic Re: making NULL value into N in QlikView

making NULL value into N

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a lot of NULL values in my table.

Is there any way I can make NULL into N?

Thank you!

Re: making NULL value into N

andrespa — Wed, 30 Mar 2016 07:18:54 GMT

Hi David, maybe something like this:

NullMap:

MAPPING LOAD

'',

'N';

TABLE:

LOAD *

ApplyMap('NullMap', YourField)

FROM [YourPath]

Hope it helps,

Andrés

Re: making NULL value into N

andrespa — Wed, 30 Mar 2016 07:30:47 GMT

Hi David, just a corrrection.

NullMap:

MAPPING

LOAD Map,

Con

FROM

[YourPath\NullTesting.xlsx]

(ooxml, embedded labels, table is Hoja2);

TABLE:

LOAD *

ApplyMap('NullMap', YourField,YourField)

FROM [YourPath]

And the mapping table works if you build something like this in for example an excel:

Map	Con
	N

And then load it as I told you before in the NullMap.

Cheers,

Andrés

Re: making NULL value into N

tamilarasu — Wed, 30 Mar 2016 07:31:37 GMT

You can replace your expression in chart like below,

=If(IsNull(FieldName),'N', FieldName)

Re: making NULL value into N

Anonymous — Wed, 30 Mar 2016 07:34:12 GMT

Hi,

you can try =if(isnull(<fieldName>),'N',<fieldName>) if the field has a null value

Re: making NULL value into N

Wed, 30 Mar 2016 07:36:14 GMT

Hi david,

in your table if you have 'NULL'

try like this

if(yourfieldname='NULL','N',yourfieldname) as new

if you have blank like( )

try like this

if(len(yourfieldname)<1,'N',yourfieldname) as new1

Re: making NULL value into N

settu_periasamy — Wed, 30 Mar 2016 07:56:45 GMT

If you want to do it in Script Lever, Try this..

SET NullValue = 'N';
NullAsValue *; // You can give the listed field names instead of * (All fields)

Re: making NULL value into N

Chanty4u — Wed, 30 Mar 2016 08:03:53 GMT

u can replace in script as

set nullvalue='N';

nullasvalue*;

it will work

Re: making NULL value into N

Kushal_Chawda — Wed, 30 Mar 2016 08:11:17 GMT

There are several ways of doing it. Please go through the below link which is having document attached

NULL handling in QlikView

Re: making NULL value into N

buzzy996 — Wed, 30 Mar 2016 09:40:55 GMT

can u try tis?