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

Announcements
Register by January 31 for $300 off your Qlik Connect pass: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
danielact
Partner - Creator III
Partner - Creator III

Difference in Pivot Chart?

Is there a way to show the difference between  the difference dimensions? I have a pivot chart with two dimensions - Dimension A goes along the side and has 2 values. Dimension B goes along the top with many more values.

I'd like to show. on the bottom, the difference between the 2 values of Dimension A for each Dimension B.

Currently, it looks like this:

          1       2       3      4       5      6        7

A1     20     30     40     50     50     60     80

A2     15     20     25     30     35     45     50

I'd like another row on the bottom that will show this:

Difference     5     10     15     20     15     15     30

Any ideas on how to do this?

0 Replies