Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
May be this?
If(IsNull(column1), 0)
Have a look at
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)