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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
curiousfellow
Specialist
Specialist

Calculate difference between two dimensions Qlikview May 2021 SR1

It seems my post disappeared (or I did not save it )

 

I have a pivot chart with columns contain a dimension and a (calculated) subdimension.

the subdimension values are not a part of the main dimension
Now I have to calculate the difference between dimension and dimension -1 . In my table I have a value "previous dimension"
I cannot find a way to make an expression that calculates the difference. 

curiousfellow_1-1683548229446.png

 

 

Labels (1)
1 Reply
Chanty4u
MVP
MVP

May be this 

Sum(Measure) - Above(Sum(Measure))