What is NULL Value Logic used to handle Nulls in QLikview ??

[nikhilgarg]

Hey,

What is NULL Value Logic used to handle Nulls in QLikview ??  Plz give an example.

Thanks

[#2]

Hi Nikhil,

have a look at the below, should give you some information on this

http://community.qlik.com/docs/DOC-3155

hope that helps

Joe

[Anonymous]

Hi

this is an example to

if(not isnull([Emp Id]),'Joined','Not Joined')

From the above expression gives the result as if emp id is null then it show as not joined ,if empid exists then it will show as Joined

[alkesh_sharma]

Hello Nikhil,

Please find the attached PDF for your reference.

[mdmukramali]

Dear,

attached blog link

http://community.qlik.com/docs/DOC-3155

Thanks,

Mukram

[#6]

null() = returns null value

isnull() = detects if null, e.g : if( isnull([field]),'X','Y')

additional :

NullAsNull

NullAsValue

Details in F1

Have fun

[its_anandrjs]

Hi,

Read this post for NULL handelling

http://community.qlik.com/docs/DOC-3155

Ex:-

This is table 

Empid	Fname	Lname
1	a
2	v	n
3	c	t
4	d	g
5	e	fr

Then in load script load it like

SET NULLINTERPRET='';

SET NULLVALUE='<Unknown>';

NULLASVALUE *;

Load * Inline [

Empid,    Fname,    Lname

1,    a,   

2,    v,    n

3,    c,    t

4,    d,    g

5,    e,    fr  ];

Regards

Anand

[Anonymous]

Hi Nikhil ,

See the example created for you .

You can load some flag in script if you want or you can use same logic in your expression to identify the NULL .

[#9]

Hi,

in addition:

reliable test if field is empty

if(len(Fieldname)=0,1,0) as Empty_Ind

goodluck