topic NULLASVALUE returning something other than NULL in QlikView

NULLASVALUE returning something other than NULL

MEJ — Wed, 25 Nov 2020 16:16:04 GMT

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

lironbaram — Mon, 17 Jun 2019 09:43:27 GMT

you should be able to do it by using this

Set NullValue = 'Others'

MEJ — Mon, 17 Jun 2019 09:50:44 GMT

Solved it. Thanks!