topic Outer Join in QlikView https://community.qlik.com/t5/QlikView/Outer-Join/m-p/264897#M1204731 <HTML><HEAD></HEAD><BODY><P>Table A &amp; B are joined by column ID. I let Qlickview do the join based on the column name (no explicit JOIN statement in script). There are some nulls in column ID in table B. When I display in straight table all columns from table B, the rows having nulls in column ID are not displayed. I thought that Qlickview default behaviour is full outer join. How can one explain above? What do I have to do to display rows with NULL's in column ID?</P><P></P><P>Thanks,</P><P>Dinesh.</P></BODY></HTML> Mon, 12 Jul 2010 02:11:28 GMT Anonymous 2010-07-12T02:11:28Z Outer Join https://community.qlik.com/t5/QlikView/Outer-Join/m-p/264897#M1204731 <HTML><HEAD></HEAD><BODY><P>Table A &amp; B are joined by column ID. I let Qlickview do the join based on the column name (no explicit JOIN statement in script). There are some nulls in column ID in table B. When I display in straight table all columns from table B, the rows having nulls in column ID are not displayed. I thought that Qlickview default behaviour is full outer join. How can one explain above? What do I have to do to display rows with NULL's in column ID?</P><P></P><P>Thanks,</P><P>Dinesh.</P></BODY></HTML> Mon, 12 Jul 2010 02:11:28 GMT https://community.qlik.com/t5/QlikView/Outer-Join/m-p/264897#M1204731 Anonymous 2010-07-12T02:11:28Z Outer Join https://community.qlik.com/t5/QlikView/Outer-Join/m-p/264898#M1204732 <HTML><HEAD></HEAD><BODY><P>Hi thonipad!</P><P>In your Straight table, try to uncheck the Supress When Value is Null (under Dimensions) and check Show All Values.</P><P></P><P>-Lester</P><P></P></BODY></HTML> Mon, 12 Jul 2010 05:31:13 GMT https://community.qlik.com/t5/QlikView/Outer-Join/m-p/264898#M1204732 2010-07-12T05:31:13Z Outer Join https://community.qlik.com/t5/QlikView/Outer-Join/m-p/264899#M1204733 <HTML><HEAD></HEAD><BODY><P>That takes me a step further. But it shows all rows from table A. What gives?</P></BODY></HTML> Mon, 12 Jul 2010 13:51:04 GMT https://community.qlik.com/t5/QlikView/Outer-Join/m-p/264899#M1204733 Anonymous 2010-07-12T13:51:04Z