Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

livio218526
Contributor

Replace null value from misures

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

1 Solution

Accepted Solutions
pradosh_thakur
Valued Contributor III

Re: Replace null value from misures

alt(your_measure,0)

4 Replies
pradosh_thakur
Valued Contributor III

Re: Replace null value from misures

alt(your_measure,0)

devarasu07
Honored Contributor II

Re: Replace null value from misures

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
Valued Contributor III

Re: Replace null value from misures

Another way to do that is:

If(IsNull(YOUR_FIELD),0)


Cheers

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
thiago_justen
Valued Contributor III

Re: Replace null value from misures

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

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
Community Browser