Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider - Maximize your investment, Join this webinar, May 26th. Register Today
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.

View solution in original post

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
Specialist III
Specialist III

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
Specialist III
Specialist III

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