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

[livio218526]

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

[adamdavi3s]

does it show as null or nothing?

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

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

[Anil_Babu_Samineni]

Image for that Null dimension?

[karthikoffi27se]

Hi

Please use this in your script.

NULLASVALUE *;

SET NullValue = '0';

This will change all null value to 0.

Many Thanks

Karthik

[tamilarasu]

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]

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

[adamdavi3s]

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

[livio218526]

Im'm using Qlik Sense Desktop!

[adamdavi3s]

Wrong forum then!