topic Re: Null to 0 in QlikView

Null to 0

pgalvezt — Fri, 13 May 2016 14:52:16 GMT

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!

Re: Null to 0

sunny_talwar — Fri, 13 May 2016 14:53:49 GMT

May be using NullAsValue

QlikView Addict: Handling Nulls in QlikView‌

NullAsValue *;

SET NullValue = 0;

Re: Null to 0

swuehl — Fri, 13 May 2016 14:55:00 GMT

You can look into

NullAsValue *;

SET NullValue = 0;

Re: Null to 0

pgalvezt — Fri, 13 May 2016 15:39:51 GMT

Hi,

Thank you for your reply,

I Try:

NullAsValue *;

Set NullValue = '0';

NullAsValue *;

Set NullValue = '';

NullAsValue *;

Set NullValue = '<NULL>';

Nothing Happened...

Re: Null to 0

swuehl — Fri, 13 May 2016 15:43:50 GMT

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

Re: Null to 0

sunny_talwar — Fri, 13 May 2016 15:48:19 GMT

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?

Re: Null to 0

pgalvezt — Fri, 13 May 2016 15:50:04 GMT

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!

Re: Null to 0

pgalvezt — Fri, 13 May 2016 15:52:25 GMT

Hi Sunny,

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