topic Re: NULLASVALUE function not working on fields that contain Null values in QVD files? in QlikView

NULLASVALUE function not working on fields that contain Null values in QVD files?

jblomqvist — Sun, 11 Oct 2015 11:52:37 GMT

Hello,

Has anyone noticed NULLASVALUE function not working on fields that contain Null values in QVD files?

E.g. If I have data loaded from QVD files and some fields have null values, the NULLASVALUE does not assign a replacement.

It works on other types of data sources.

swuehl — Sun, 11 Oct 2015 12:33:44 GMT

Have you tried with an unoptimized QVD LOAD (e.g. using ...WHERE 1=1)?

nizamsha — Sun, 11 Oct 2015 14:06:52 GMT

As my understanding is correct that u r telling null function is not working in QVD .have u checked in this manner

if(isnull(Urfield)=-1,'Null',urField) as Field

if its not working

if(trim(len(urfield))>=1,urfield,'Null')

anyone will work in your scenario