topic null as value? in QlikView

null as value?

Sun, 16 Nov 2014 18:45:50 GMT

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?

Re: null as value?

morgankejerhag — Sun, 16 Nov 2014 19:29:56 GMT

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.

Re: null as value?

hic — Sun, 16 Nov 2014 19:41:58 GMT

See NULL handling in QlikView

HIC

Re: null as value?

nickmarlborough — Mon, 19 Aug 2024 13:58:23 GMT

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?