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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to do calculation between two fields of different pivot tables.

Facing an issue to do calculation between two fields of two different pivot tables, because there is no common key.

The scenario is as below

First Pivot Table:                                                            Second Table

campaign Year         2013                      2014                   Subscribed Year      2013                 2014 

Camp Quarter        Q1   Q2 Q3           Q1 Q2 Q3                Sub Quarter        Q1  Q2   Q3       Q1  Q2   Q3

A1                         2      4    6              1   4     5                     A1             3    5      9          1    4     5

A2                         3       3    4             2   5     7                      A2             4    6      7           2    5    6

Output Should be Sum of values for particular quarter

Output Year           2013                      2014

                            Q1   Q2 Q3            Q1  Q2  Q3

A1                        5      9    15            2       8    10

A2                          7    9   11             4    10     13

Please note A1 ,A2 ,Subscribed Year,Campaign Year and the quarters are calcaluted dimensions.

Please let me know how to solve this.

0 Replies