Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
er_mohit
Master II
Master II

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
Master II
Master II

Hi in qlikview write condition for that particular field

like

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

PrashantSangle

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.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
ariel_klien
Specialist
Specialist

Hi,


you can do in the script...

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

from xlsx

BR

Ariel

Not applicable
Author

Thanks! Works perfectly!