topic Inner Join, Outer Join, and Subtract between pivot tables in QlikView https://community.qlik.com/t5/QlikView/Inner-Join-Outer-Join-and-Subtract-between-pivot-tables/m-p/517298#M481056 <HTML><HEAD></HEAD><BODY><P>I have 2 pivot tables on 2 different tabs (in my attached file, they are on 'leaf1' and 'leaf2' tab). By selecting a logic box with value 'and', 'or', 'exclude'&nbsp; on 1st tab ('leaf1'), I want to create a final pivot table on a 3rd tab (referred as 'tree' tab in my file), that shows data by 'inner joining', 'outer joining', 'subtracting leaf1 from leaf2' data between previous 2 pivot tables.</P><P></P><P>Could I know how to do this?</P><P></P><P>Thanks</P></BODY></HTML> Thu, 24 Oct 2013 05:26:55 GMT 2013-10-24T05:26:55Z Inner Join, Outer Join, and Subtract between pivot tables https://community.qlik.com/t5/QlikView/Inner-Join-Outer-Join-and-Subtract-between-pivot-tables/m-p/517298#M481056 <HTML><HEAD></HEAD><BODY><P>I have 2 pivot tables on 2 different tabs (in my attached file, they are on 'leaf1' and 'leaf2' tab). By selecting a logic box with value 'and', 'or', 'exclude'&nbsp; on 1st tab ('leaf1'), I want to create a final pivot table on a 3rd tab (referred as 'tree' tab in my file), that shows data by 'inner joining', 'outer joining', 'subtracting leaf1 from leaf2' data between previous 2 pivot tables.</P><P></P><P>Could I know how to do this?</P><P></P><P>Thanks</P></BODY></HTML> Thu, 24 Oct 2013 05:26:55 GMT https://community.qlik.com/t5/QlikView/Inner-Join-Outer-Join-and-Subtract-between-pivot-tables/m-p/517298#M481056 2013-10-24T05:26:55Z