Delta Calculation of same dimension and same measure
Hi everyone,
as I'm a big fan of Qlik Sense and this Community I'm trying my luck here to find a solution to my issue.
I am trying to compare the values of the same dimension with each other. The Dataset looks like this:
Dimension 1
Measure 1
A
1
B
2
C
3
D
4
Now I would like to show the Delta values of the "Measure 1" of each distinct value of the "Dimension 1". At the end, I would like to see some sort of a heatmap like this.
Delta
A
B
C
D
A
0
1
2
3
B
-1
0
1
2
C
-2
-1
0
1
D
-3
-2
-1
0
I'm kind of lost, as I'm sure there should be an easy solution for that.