https://community.qlik.com/t5/App-Development/Calculate-difference-between-two-dimensions-Qlikview-May-2021/m-p/2068667#M87650 <P>It seems my post disappeared (or I did not save it )</P> <P>&nbsp;</P> <P>I have a pivot chart with columns contain a dimension and a (calculated) subdimension.</P> <P>the subdimension values are not a part of the main dimension<BR />Now I have to calculate the difference between dimension and dimension -1 . In my table I have a value "previous dimension"<BR />I cannot find a way to make an expression that calculates the difference.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="curiousfellow_1-1683548229446.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/106636i4423487E7EA58F43/image-size/medium?v=v2&amp;px=400" role="button" title="curiousfellow_1-1683548229446.png" alt="curiousfellow_1-1683548229446.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 08 May 2023 12:20:49 GMT curiousfellow 2023-05-08T12:20:49Z https://community.qlik.com/t5/App-Development/Calculate-difference-between-two-dimensions-Qlikview-May-2021/m-p/2068667#M87650 <P>It seems my post disappeared (or I did not save it )</P> <P>&nbsp;</P> <P>I have a pivot chart with columns contain a dimension and a (calculated) subdimension.</P> <P>the subdimension values are not a part of the main dimension<BR />Now I have to calculate the difference between dimension and dimension -1 . In my table I have a value "previous dimension"<BR />I cannot find a way to make an expression that calculates the difference.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="curiousfellow_1-1683548229446.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/106636i4423487E7EA58F43/image-size/medium?v=v2&amp;px=400" role="button" title="curiousfellow_1-1683548229446.png" alt="curiousfellow_1-1683548229446.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 08 May 2023 12:20:49 GMT https://community.qlik.com/t5/App-Development/Calculate-difference-between-two-dimensions-Qlikview-May-2021/m-p/2068667#M87650 curiousfellow 2023-05-08T12:20:49Z https://community.qlik.com/t5/App-Development/Calculate-difference-between-two-dimensions-Qlikview-May-2021/m-p/2069332#M87685 <P>May be this&nbsp;</P> <P>Sum(Measure) - Above(Sum(Measure))</P> <P>&nbsp;</P> Tue, 09 May 2023 18:09:06 GMT https://community.qlik.com/t5/App-Development/Calculate-difference-between-two-dimensions-Qlikview-May-2021/m-p/2069332#M87685 Chanty4u 2023-05-09T18:09:06Z