topic Null as value in QlikView

Null as value

Anonymous — Mon, 18 Jan 2016 11:22:35 GMT

Hi all,

I'm using 'Null as Value' function in load script and applying it in all fields. Is there an easy way to apply in all and exclude some?

Today I know that if you want some fields to be filled with null you just apply null as value on them, but for debugging purposes I would like to go excluding some of fields from this function. For example, take the load script:

Load

drop field 'value' ;

Is there a way to do that?

Re: Null as value

Gysbert_Wassenaar — Mon, 18 Jan 2016 18:32:20 GMT

You can use NullAsNull to disable the NullAsValue for some fields:

//This enables NullAsValue for all fields except FieldA en FieldB.

NullAsValue *;

NullAsNull FieldA, FieldB;

// Load some data

MyTable

LOAD

FieldA, FieldB, FieldC, FieldD

FROM

MySource;

// Enable NullAsValue for all fields again

NullAsValue *;

Re: Null as value

Mon, 18 Jan 2016 18:38:20 GMT

You can use NullAsValue & NullAsNull functions to manipulate the null values.

Re: Null as value

Anonymous — Mon, 18 Jan 2016 19:04:18 GMT

Thanks Gysbert!

It helped a lot.

I've got another question: including lastworkdate in a chart
Any help would be appreciated.