topic Re: Null values in QlikView

Null values

rathnam_qv — Wed, 26 Jun 2013 01:27:17 GMT

Hi All,

how to handle null values through script

Regards

smiley

Sokkorn — Wed, 26 Jun 2013 01:46:28 GMT

Hi Muni,

There are lots of NULL discussion. See here and here

Regards,

Sokkorn

Wed, 26 Jun 2013 01:48:11 GMT

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

Wed, 26 Jun 2013 02:52:45 GMT

in the script, add below statement

SET NullAsValue ='<Null>';

Wed, 26 Jun 2013 05:00:08 GMT

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.

er_mohit — Sat, 06 Jul 2013 06:02:16 GMT

Hope it helps