Null to 0

[pgalvezt]

Hello,

Is there a way to carry all values nulls to 0 in all fields?

I´m reading many xls. Each xls has values nulls that thrown bad results in my final formulas. Is because QlikView is not taking that values into the analysis and formulas. I would like that in my load model when qlikview find a null value.. this value be transform to 0...

Thanks!

[sunny_talwar]

May be using NullAsValue

QlikView Addict: Handling Nulls in QlikView‌

NullAsValue *;

SET NullValue = 0;

[swuehl]

You can look into

NullAsValue *;

SET NullValue = 0;

[pgalvezt]

Hi,

Thank you for your reply,

I Try:

NullAsValue *;

Set NullValue = '0';

NullAsValue *;

Set NullValue = '';

NullAsValue *;

Set NullValue = '<NULL>';

Nothing Happened...

[swuehl]

Could you upload a sample Excel file? Are these nulls really NULL and not just empty values?

[sunny_talwar]

I think NullAsValue cannot handle null values created by join. Is it possible that you are doing a join which might be creating these nulls for you?

[pgalvezt]

Empty Values,

As you can see in the first post (Image) The spaces are empty.

I would like to fill up with 0 values.

Thanks!

[pgalvezt]

Hi Sunny,

The answers is no... Im readind the base directly from xls. There is no join and nothing about it...