Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Upload "blanks" with default value

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

Tags (3)
1 Solution

Accepted Solutions
er_mohit
Honored Contributor II

Re: Upload "blanks" with default value

Hi in qlikview write condition for that particular field

like

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

View solution in original post

4 Replies
er_mohit
Honored Contributor II

Re: Upload "blanks" with default value

Hi in qlikview write condition for that particular field

like

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

View solution in original post

Re: Upload "blanks" with default value

Hi,

If you want to write in script

Then

try like

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

or

If you want to write in chart

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
ariel_klien
Valued Contributor

Re: Upload "blanks" with default value

Hi,


you can do in the script...

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

from xlsx

BR

Ariel

Not applicable

Re: Upload "blanks" with default value

Thanks! Works perfectly!