Discussion Board for collaboration related to Creating Analytics for QlikView.
I'd like to convert the value from null to 0 for all dimension that i?m uploading.
How I can do it??
Image for that Null dimension?
Please use this in your script.
SET NullValue = '0';
This will change all null value to 0.
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.