Define default Null value handling

[spcon2016]

Hi community,

when I try to load data from .xlsx, qlik doesn't recognize the null values. But after loading the same data with .csv everthing seems to be fine.

I found this solution and it worked.

NullAsValue Flagfield_with_XLSX;
Set NullValue = '';

My question is: Is there a possibility to do the same without entering specific field name? I mean, a default handeling for those kind of null-values. My qlik application has many fields and I don't want to check them all for null-values.

[atoz1158]

Hi

A comma separated list of the fields for which NullAsValue should be turned on. Using * as field list indicates all fields. The wildcard characters * and ? are allowed in field names. Quoting of field names may be necessary when wildcards are used.

HTH

Adrian

[MikeW · Accepted solution]

I think NullAsValue *; will apply to all fields. Then you can use NullAsNull *; after loading from Excel to set it back to normal.