Null values

[rathnam_qv]

Hi All,

how to handle null values through script

Regards

smiley

[Sokkorn]

Hi Muni,

There are lots of NULL discussion. See here and here

Regards,

Sokkorn

[#3]

you can use len(FIELD)=0 to identify null values and use it in the load sript or even the where clause

[#4]

in the script, add below statement

SET NullAsValue ='<Null>';

[#5]

hi

There are many ways to handle null values.

You can test if a value is a null with the isnull( expression )

you can generate a null value with null()

You can use nullcount() as you use count() to count null values (script or in a chart)

You can use NullasValue to define the the null values in a field should be considerer as regular values for selections.

for more details see link.

http://community.qlik.com/docs/DOC-3155
http://community.qlik.com/thread/62255
http://www.qlikviewaddi...

[er_mohit]

Hope it helps

http://www.youtube.com/watch?v=UkKTmnKSNQo