Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

COMPARISON PIVOT TABLES

Hi community,

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?

Thanks

1 Reply
vgutkovsky
Master II
Master II

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.

Regards,