Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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