Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

livio218526
Contributor

replace blank with 0

Hi Everyone,

How can replace all blank value with 0 for all columns?

Thanks,
Livio

Tags (2)
3 Replies
agigliotti
Honored Contributor II

Re: replace blank with 0

you are talking about UI or script ?

OmarBenSalem
Esteemed Contributor

Re: replace blank with 0

Maybe :
if(len(trim(YourField))=0,0,YourField)

livio218526
Contributor

Re: replace blank with 0

Script. I've a lot of measure and i want replace blank value for all. There is a function difference to if?

Community Browser