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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Subtraction of dimensions in a pivot table.

I have a pivot table which has 2 dimensions and want to add a further dimension which makes me a subtraction of the 2 dimensions that are above. Can this be done in a pivot table?

Thanks!

2 Replies
robert_mika
Master III
Master III

Not sure about the word "above"

But you can add an expression

Dimension1 -Dimension2

Not applicable
Author

Resta.jpg

Thanks for your answer, I attached an image to make it more useful, I want to make the subtraction to the field records "Revenue" and "Operating Costs" and display the subtraction in the "Subtraction" field, this in a pivot table.