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.
Thanks a lot in advanced. Appreciate your help!