Set null values for all fields in app

[Taylorcc]

Hello, 

I have loaded a spreadsheet with 40 different fields into my app - each field contains a few blank cells 

Is there a way I can set null values in the script to display as 'Blank' on charts? 

I know I can use set nulls in the data manager but I have so many fields to do that for 

Thank you 

[tresesco]

You can try using variable setting like:

NullAsValue '*';     // '*' indicates here for all fields.

Set NullValue = 'NULL';