topic Re: Upload "blanks" with default value in QlikView

Upload "blanks" with default value

Mon, 13 Oct 2014 10:27:46 GMT

Hi everyone,

In one column of my Excel raw data file there are some "blanks", where no value is assigned to the row (yet).

Is there any way to assign a default value to these blank fields?

Thanks in advance,

Lina

er_mohit — Mon, 13 Oct 2014 10:32:21 GMT

Hi in qlikview write condition for that particular field

If(len(Field)=0,'Default',Field) as NewField

PrashantSangle — Mon, 13 Oct 2014 10:32:48 GMT

Hi,

If you want to write in script

Then

try like

IF(ISNull(FieldNAme) or len(trim(FieldName))=0,'No Data') as NewFieldName.

If you want to write in chart

then go to Presentation->Null Symbol->write Value

Regards

ariel_klien — Mon, 13 Oct 2014 10:33:49 GMT

Hi,

you can do in the script...

load if(isnull(Column),defalt_value,Column) as Column

from xlsx

Ariel

Mon, 13 Oct 2014 10:36:08 GMT

Thanks! Works perfectly!