topic Delta Calculation of same dimension and same measure in App Development https://community.qlik.com/t5/App-Development/Delta-Calculation-of-same-dimension-and-same-measure/m-p/1789263#M61655 <P>Hi everyone,</P><P>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.</P><P>I am trying to compare the values of the same dimension with each other. The Dataset looks like this:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Dimension 1</TD><TD>Measure 1</TD></TR><TR><TD>A</TD><TD>1</TD></TR><TR><TD>B</TD><TD>2</TD></TR><TR><TD>C</TD><TD>3</TD></TR><TR><TD>D</TD><TD>4</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>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.</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Delta</TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD></TR><TR><TD>A</TD><TD>0</TD><TD>1</TD><TD>2</TD><TD>3</TD></TR><TR><TD>B</TD><TD>-1</TD><TD>0</TD><TD>1</TD><TD>2</TD></TR><TR><TD>C</TD><TD>-2</TD><TD>-1</TD><TD>0</TD><TD>1</TD></TR><TR><TD>D</TD><TD>-3</TD><TD>-2</TD><TD>-1</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I'm kind of lost, as I'm sure there should be an easy solution for that.</P><P>Thanks a lot in advanced. Appreciate your help!</P> Sat, 16 Nov 2024 17:24:45 GMT CK_QLIKSENSE 2024-11-16T17:24:45Z Delta Calculation of same dimension and same measure https://community.qlik.com/t5/App-Development/Delta-Calculation-of-same-dimension-and-same-measure/m-p/1789263#M61655 <P>Hi everyone,</P><P>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.</P><P>I am trying to compare the values of the same dimension with each other. The Dataset looks like this:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Dimension 1</TD><TD>Measure 1</TD></TR><TR><TD>A</TD><TD>1</TD></TR><TR><TD>B</TD><TD>2</TD></TR><TR><TD>C</TD><TD>3</TD></TR><TR><TD>D</TD><TD>4</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>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.</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Delta</TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD></TR><TR><TD>A</TD><TD>0</TD><TD>1</TD><TD>2</TD><TD>3</TD></TR><TR><TD>B</TD><TD>-1</TD><TD>0</TD><TD>1</TD><TD>2</TD></TR><TR><TD>C</TD><TD>-2</TD><TD>-1</TD><TD>0</TD><TD>1</TD></TR><TR><TD>D</TD><TD>-3</TD><TD>-2</TD><TD>-1</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I'm kind of lost, as I'm sure there should be an easy solution for that.</P><P>Thanks a lot in advanced. Appreciate your help!</P> Sat, 16 Nov 2024 17:24:45 GMT https://community.qlik.com/t5/App-Development/Delta-Calculation-of-same-dimension-and-same-measure/m-p/1789263#M61655 CK_QLIKSENSE 2024-11-16T17:24:45Z