Discussion Board for collaboration related to QlikView App Development.
Can I somehow do it easily for each field?
May be something like this
maybe you can use
of the NullAsValue statement.
The NullAsValue statement operates as a switch and will operate on subsequent loading statements. It can
be switched off again by means of the NullAsNull statement
A youtube video on the topic
Convert Null values using NullAsValue statement in QlikView - YouTube
I have not seen it, but I think it should help
I don't have null values but empty strings from excel. Is here a similar way for this?
Well that would be somewhat more challenging...may be loop through each field and use ApplyMap to change blanks to something else
I think you could adapt these approach: Filling Default Values Using Mapping | Qlikview Cookbook.