Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
livio218526
Creator
Creator

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
Master
Master

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?

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
Creator III
Creator III

Hi

Please use this in your script.

NULLASVALUE *;

SET NullValue = '0';


This will change all null value to 0.


Many Thanks

Karthik



tamilarasu
Champion
Champion

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
Creator
Creator
Author

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

adamdavi3s
Master
Master

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

null.PNG

livio218526
Creator
Creator
Author

Im'm using Qlik Sense Desktop!

adamdavi3s
Master
Master

Wrong forum then!