null as value?

[#1]

Hi can any one give example with script for how to calculate  null values

pls give examples for

null as value

null as nullvalue

?

how many ways are there to remove null?

how to assign a null to one field?

[morgankejerhag]

Hi,

NULL values are usually not represented in list boxes in QlikView. The user can not click on the NULL value and select it. If you want to let the user click on a value that represents all NULL values you can use the function NullAsValue. First set the label that the values should get:

NullAsValue CustomerNo, Name;

Set NullValue = 'NULL' ;

I am not sure what you mean by "removing null". If you by "remove" mean assign value you can use NullAsValue and you could also do something manual like if(isnull(Field),'NULL',Field) as Field.

[hic]

See NULL handling in QlikView

HIC

[nickmarlborough]

Hi, 

is there a way to have every column loaded into Qlik take a default NULL value 

for example if null then 'N/A' thats applicable for the whole data load?