Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Inner Join, Outer Join, and Subtract between pivot tables

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'  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.

Could I know how to do this?

Thanks

Community Browser