Replace null value from misures

[livio218526]

Hi Everyone,

I'd like to convert the value from null to 0 for all columns (calculated misures) that i'm uploading.

How I can do it??

Thanks,

Livio

[pradosh_thakur · Accepted solution]

alt(your_measure,0)

[devarasu07]

Hi,

by using Alt function u can do that.

let's say u have Measure as Sales and it contains null then simply use alt function like below

alt( sum(Sales),0) // this will replace null as 0

method 2:

try to set null as value in back end script

NullAsValue ‒ Qlik Sense

thanks,

Deva

[Thiago_Justen_]

Another way to do that is:

If(IsNull(YOUR_FIELD),0)

Cheers

[Thiago_Justen_]

Take care about Alt() function, cause it works like this:

The alt function is often used with number or date interpretation functions. This way, Qlik Sense can test different date formats in a prioritized order. It can also be used to handle NULL values in numerical expressions.

What it means? If you have a field with non numeric values, maybe Alt function will not solve your problem.

Cheers