Discussion Board for collaboration related to QlikView App Development.
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,
Go to Solution.
Hi in qlikview write condition for that particular field
If(len(Field)=0,'Default',Field) as NewField
View solution in original post
If you want to write in script
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
you can do in the script...
load if(isnull(Column),defalt_value,Column) as Column
Thanks! Works perfectly!