topic COMPARISON PIVOT TABLES in QlikView https://community.qlik.com/t5/QlikView/COMPARISON-PIVOT-TABLES/m-p/220977#M73834 <HTML><HEAD></HEAD><BODY><P>Hi community,</P><P>Under Qlikview, given two different files Qlikview which each include a sheet with a PivotTables object, there does - there a way to compare the values of two cells of each table?</P><P>Thanks<BR /></P></BODY></HTML> Tue, 28 Sep 2010 17:35:41 GMT 2010-09-28T17:35:41Z COMPARISON PIVOT TABLES https://community.qlik.com/t5/QlikView/COMPARISON-PIVOT-TABLES/m-p/220977#M73834 <HTML><HEAD></HEAD><BODY><P>Hi community,</P><P>Under Qlikview, given two different files Qlikview which each include a sheet with a PivotTables object, there does - there a way to compare the values of two cells of each table?</P><P>Thanks<BR /></P></BODY></HTML> Tue, 28 Sep 2010 17:35:41 GMT https://community.qlik.com/t5/QlikView/COMPARISON-PIVOT-TABLES/m-p/220977#M73834 2010-09-28T17:35:41Z COMPARISON PIVOT TABLES https://community.qlik.com/t5/QlikView/COMPARISON-PIVOT-TABLES/m-p/220978#M73835 <HTML><HEAD></HEAD><BODY><P>If I understood your question correctly, you're asking if there's a way to compare the values of 2 cells in 2 different pivot tables? No, not directly. But you should be able to recreate the first table within the second table using the AGGR function. For example, if your first table has Expression1 aggregated over Dimension1 and Dimension2 and your second table has Expression2 aggregated over Dimension3 and Dimension4, you can add a second expression to your second table: sum(aggr(Expression1,Dimension1,Dimension2)) and then compare the Expression2 to this second expression.</P><P>Regards,</P></BODY></HTML> Tue, 28 Sep 2010 23:06:40 GMT https://community.qlik.com/t5/QlikView/COMPARISON-PIVOT-TABLES/m-p/220978#M73835 vgutkovsky 2010-09-28T23:06:40Z