Null handling

[#1]

Hi guys

I have Category field in my Dashboard.

There is missing or null values as well in the column. Requirement is to define null values or missing values to ' NA' Category. I have used below expression for this in my script while loading Category field.

If(Len(Category)=0 OR Category='','NA', Category) as Category.

But still I could see blank values in the Category legend of my chart. Could you please help me in this.

[satishkurra]

Try this for handling and showing blank values as NA in chart

=if(len(trim(Category))=0,'NA',Category)

[PradeepReddy]

you can also try this in script...

SET  NULLVALUE ='NA';

NULLASVLUE  Category;

Load Field1, Field2, Category from File;