Default values

[dmxmikey]

I have created a report that i export and some of the fields are blank in database.  below is a sample of data and was wondering if its possible on my script to say  if blank or ( - ) use default?

the data is coming from multiple tables.

Code	Iron	cho	description
5	-		test
6	5	1
4	4	4	via

[Chanty4u]

if blank what do you want to see ?

[YoussefBelloum]

Hi,

what do you mean USE DEFAULT ?

[remi_roland]

Hi,

You can set a value instead of null for some columns only or every column (replace F1 by *);

It will write the value instead of null inside the data model.

NullAsValue F1;

Set NullValue = 'NULL';

LOAD null() as F1 AutoGenerate 1;

If you are using qlikview and if you want do that only in your table

You can do properties on the graph -> presentation tab you will have null symbol and missing symbol you can replace.

Regards

[dmxmikey]

if blank return empty

[Chanty4u]

try this in script

if(len(trim(Field))=0, '',Field) as NewField