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: 
patrickbender
Contributor III
Contributor III

NullAsValue not working

Hi I have the below code that i am trying to get the Null value to equal 0.

For some reason it is not working, could it be that i'm reading data from txt & xlsx files?

There is some more code (see attachment) but even if I only try this shorter example the Null values are still not changing.

Any ideas?

NULLASVALUE *;

SET NullValue = 0 ;


LOAD [FGLEDG_År],

[FGLEDG_Verifikat],

[FGLEDG_VerBeskr],

[FGLEDG_VerText],

[FGLEDG_Bokföringsdatum],

[FGLEDG_BokförtBelopp],

[FGLEDG_Konto] As Kontonr,

[FGLEDG_Ansvar] As Ansvarnr,

[FGLEDG_Projekt] As Projektnr

FROM [lib://CSVfiler/Huvudbok_BYG.csv]

(txt, utf8, embedded labels, delimiter is ',', msq);


[Projektnamn]:

LOAD [Kont beg] As Projektnr,

[Beskrivning]

FROM [lib://Byggsystem/QVS uppdelning.xlsx]

(ooxml, embedded labels, table is Projektnamn);

1 Reply
patrickbender
Contributor III
Contributor III
Author

This was the solution for me:

SET NullInterpret = '';

Apparently it didn't read excels empty strings as Null