Discussion Board for collaboration related to Creating Analytics for QlikView.
I wanna know If there I could put a value defect insted of NULL when I use Outer Join Sentense.
You could try something like this
LEFT JOIN (MainTable)LOAD ... [from your join table]
MainTable2:LOAD *,if (isnull(joinedvalue),defaltvalue, joinedvalue) as ValueRESIDENT MainTable;
Alternatively, if your tables have a one to one relationship, an ApplyMap allows you to specify a default value.
The NullAsValue load script statement may be of use to you.
Best Regards, Bill