Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
Contributor II

Replace all empty strings with some value in entire script.

Can I somehow do it easily for each field?

Thanks

6 Replies
Highlighted

Re: Replace all empty strings with some value in entire script.

May be something like this

NullAsValue

Highlighted
Valued Contributor III

Re: Replace all empty strings with some value in entire script.

hello

maybe you can use

nullasvalue

NullAsValue *fieldlist

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

Highlighted

Re: Replace all empty strings with some value in entire script.

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

Highlighted
Contributor II

Re: Replace all empty strings with some value in entire script.

Hi,

I don't have null values but empty strings from excel. Is here a similar way for this?

Thank you.

Highlighted

Re: Replace all empty strings with some value in entire script.

Well that would be somewhat more challenging...may be loop through each field and use ApplyMap to change blanks to something else

Highlighted
MVP & Luminary
MVP & Luminary

Re: Replace all empty strings with some value in entire script.

I think you could adapt these approach: Filling Default Values Using Mapping | Qlikview Cookbook.

- Marcus