topic How to replace null values in QlikView

How to replace null values

Wed, 25 Nov 2020 16:16:04 GMT

Hallo guyz,

I have a dimension where mapping has been implemented. I tried including null() to be replaced with a value but it is not working. What am i doing wrong? Please have a look at the attachment if you want to have a look.

Thanks in advance.

Re: How to replace null values

trdandamudi — Fri, 19 Aug 2016 13:53:59 GMT

Instead of mapping you can use the below:

Place the below two line at the start of the script:

NullAsValue *;

Set NullValue = 'Test2';

Re: How to replace null values

beck_bakytbek — Fri, 19 Aug 2016 14:36:12 GMT

Hi Ismael,

check this: Show date Dates with 0 value if data not available

i hope that helps

beck

Re: How to replace null values

Fri, 19 Aug 2016 14:56:41 GMT

Hi Thirumala,

I only want to replace null values from a specific field. Will yours replace all null values?

Re: How to replace null values

trdandamudi — Fri, 19 Aug 2016 15:49:47 GMT

Yes, you can do that as below. Say for example you have fields A,B and C and you want to apply null for field A then do as below:

NullAsValue A;

Set NullValue = 'Test2';

If it is one filed you can also do as below in the script:

if(isnull(columnName), 'Test2',columnName)

Note: replace columnName with the right column in your source.

Re: How to replace null values

Fri, 19 Aug 2016 19:58:09 GMT

Thx for the assistance, the isnull part didnt work with my issue. I changed it to len() after reading becky's link. So both of you, thank you very much.

Re: How to replace null values

Fri, 19 Aug 2016 19:58:26 GMT

Thx for the assistance, the isnull part didnt work with my issue. I changed it to len() after reading becky's link. So both of you, thank you very much.

Re: How to replace null values

trdandamudi — Fri, 19 Aug 2016 20:05:27 GMT

You are welcome... Glad you got the solution..

Re: How to replace null values

beck_bakytbek — Fri, 19 Aug 2016 22:30:54 GMT

Hi Ismael,

Glad to help you, Learning by doing, You are welcome

beck