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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
MEJ
Contributor III
Contributor III

NULLASVALUE returning something other than NULL

I use NULLASVALUE quite a lot when cell values are blank. With NULLASVALUE, I always get NULL as the default value. 

Is it possible to rename it to OTHERS instead, just like it is possible for renaming fields in the load script?

Thanks,

Mathias

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi 

you should be able to do it by using this 

Set NullValue = 'Others'

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

you should be able to do it by using this 

Set NullValue = 'Others'

MEJ
Contributor III
Contributor III
Author

Solved it. Thanks!