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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
livio218526
Creator
Creator
‎2018-01-26 10:39 AM

replace blank with 0

Hi Everyone,

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

Thanks,
Livio

2,197 Views
0 Likes
3 Replies
agigliotti
MVP
MVP
‎2018-01-26 10:50 AM

you are talking about UI or script ?

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
2,061 Views
0 Likes
OmarBenSalem
Partner - Champion II
Partner - Champion II
‎2018-01-26 10:55 AM

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

2,061 Views
0 Likes
livio218526
Creator
Creator
‎2018-01-26 11:02 AM
Author

In response to agigliotti

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

2,061 Views
0 Likes