Qlik Community

New to Qlik Sense

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

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
livio218526
Creator
Creator

replace blank with 0

Hi Everyone,

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

Thanks,
Livio

3 Replies
agigliotti
Partner
Partner

you are talking about UI or script ?

OmarBenSalem
Partner
Partner

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

livio218526
Creator
Creator
Author

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