Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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 - Champion
Partner - Champion

you are talking about UI or script ?

OmarBenSalem

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?