Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

coddra_6
New Contributor II

Outer Join With a default value insted of NULL

Hey,

I wanna know If there I could put a value defect insted of NULL when I use Outer Join Sentense.

2 Replies
marcus_malinow
Valued Contributor III

Re: Outer Join With a default value insted of NULL

Hi Dario,

You could try something like this


MainTable:
LOAD ......


LEFT JOIN (MainTable)
LOAD ... [from your join table]

MainTable2:
LOAD *,
if (isnull(joinedvalue),defaltvalue, joinedvalue) as Value
RESIDENT MainTable;

Alternatively, if your tables have a one to one relationship, an ApplyMap allows you to specify a default value.

Marcus

Re: Outer Join With a default value insted of NULL

Dario

The NullAsValue load script statement may be of use to you.

Best Regards,     Bill

Community Browser