Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
spcon2016
Partner
Partner

Define default Null value handling

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.

flagfield.png

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.

Labels (1)
  • Null

1 Solution

Accepted Solutions
MikeW
Creator
Creator

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

View solution in original post

2 Replies
atoz1158
Creator II
Creator II

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
Creator
Creator

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

View solution in original post