What is the function used to treat null values?

[Anonymous]

Hi,

I wanted to replace null values with 0 or 1 ,so how can I achieve it in Qlikview?

For example: ifnull(column1, 0)

explanation: If column1 is null then it will replace null values to 0.

Thanks.

[rubenmarin]

Hi Rashika, maybe with IsNull():

If(IsNull(Column1), 0)

Also, to count empty spaces as null this can be used:

If(Len(Trim(Column1))=0, 0)

[Anil_Babu_Samineni]

May be this?

If(IsNull(column1), 0)

[swuehl]

Have a look at

NULL handling in QlikView

[jonathandienst]

Alt() is the function in QV that is much like your ifnull() example. It will return the first valid numericvalue, so it is good for dates and amounts. It does not handle text values.

example:

     Alt(column1, 0)