topic What is the function used to treat null values? in QlikView

What is the function used to treat null values?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: What is the function used to treat null values?

rubenmarin — Thu, 12 Oct 2017 11:21:46 GMT

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)

Re: What is the function used to treat null values?

Anil_Babu_Samineni — Thu, 12 Oct 2017 11:21:54 GMT

May be this?

If(IsNull(column1), 0)

Re: What is the function used to treat null values?

swuehl — Thu, 12 Oct 2017 11:21:57 GMT

Have a look at

NULL handling in QlikView

Re: What is the function used to treat null values?

jonathandienst — Thu, 12 Oct 2017 11:36:07 GMT

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)