Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
livio218526
Contributor

NVL, change all null value for all dimension in 0 value

Hi Everyone,

I'd like to convert the value from null to 0 for all dimension that i?m uploading.

How I can do it??

Thanks,

Livio

8 Replies
adamdavi3s
Honored Contributor

Re: NVL, change all null value for all dimension in 0 value

does it show as null or nothing?

if(len(dimension)<1,0,dimension)

if(dimension='null',0,dimension)

Re: NVL, change all null value for all dimension in 0 value

Image for that Null dimension?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
karthikoffi27se
Contributor III

Re: NVL, change all null value for all dimension in 0 value

Hi

Please use this in your script.

NULLASVALUE *;

SET NullValue = '0';


This will change all null value to 0.


Many Thanks

Karthik



Re: NVL, change all null value for all dimension in 0 value

Hi Livio,

If you want to change the null to 0 for specific columns, you can try like below.

NullAsValue Field_Name1, Field_Name2....... etc;
Set NullValue = 0;

Note: Make sure to paste this statement before the data loaded into the application.

livio218526
Contributor

Re: NVL, change all null value for all dimension in 0 value

I have misure and no dimension. I've tried with your code but it isn't work again.

adamdavi3s
Honored Contributor

Re: NVL, change all null value for all dimension in 0 value

If it is a measure then just change the chart setting:

null.PNG

livio218526
Contributor

Re: NVL, change all null value for all dimension in 0 value

Im'm using Qlik Sense Desktop!

adamdavi3s
Honored Contributor

Re: NVL, change all null value for all dimension in 0 value

Wrong forum then!