topic Re: Define default Null value handling in QlikView

Define default Null value handling

spcon2016 — Sat, 16 Nov 2024 00:59:05 GMT

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.

Re: Define default Null value handling

atoz1158 — Wed, 25 Mar 2020 11:31:49 GMT

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

Re: Define default Null value handling

MikeW — Wed, 25 Mar 2020 11:34:12 GMT

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