Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
livio218526
Creator
Creator

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
Master II
Master II

alt(your_measure,0)

Learning never stops.

View solution in original post

4 Replies
pradosh_thakur
Master II
Master II

alt(your_measure,0)

Learning never stops.
devarasu07
Master II
Master II

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 Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
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

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