topic Difference in Pivot Chart? in QlikView https://community.qlik.com/t5/QlikView/Difference-in-Pivot-Chart/m-p/372580#M138523 <HTML><HEAD></HEAD><BODY><P>Is there a way to show the difference between&nbsp; the difference dimensions? I have a pivot chart with two dimensions - Dimension A goes along the side and has 2 values. Dimension B goes along the top with many more values.</P><P></P><P>I'd like to show. on the bottom, the difference between the 2 values of Dimension A for each Dimension B. </P><P></P><P>Currently, it looks like this:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</P><P>A1&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp; 40&nbsp;&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp;&nbsp; 60&nbsp;&nbsp;&nbsp;&nbsp; 80</P><P>A2&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp; 25&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp; 35&nbsp;&nbsp;&nbsp;&nbsp; 45&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P></P><P>I'd like another row on the bottom that will show this:</P><P></P><P>Difference&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P></P><P>Any ideas on how to do this?</P></BODY></HTML> Tue, 29 May 2012 14:36:13 GMT danielact 2012-05-29T14:36:13Z Difference in Pivot Chart? https://community.qlik.com/t5/QlikView/Difference-in-Pivot-Chart/m-p/372580#M138523 <HTML><HEAD></HEAD><BODY><P>Is there a way to show the difference between&nbsp; the difference dimensions? I have a pivot chart with two dimensions - Dimension A goes along the side and has 2 values. Dimension B goes along the top with many more values.</P><P></P><P>I'd like to show. on the bottom, the difference between the 2 values of Dimension A for each Dimension B. </P><P></P><P>Currently, it looks like this:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</P><P>A1&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp; 40&nbsp;&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp;&nbsp; 60&nbsp;&nbsp;&nbsp;&nbsp; 80</P><P>A2&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp; 25&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp; 35&nbsp;&nbsp;&nbsp;&nbsp; 45&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P></P><P>I'd like another row on the bottom that will show this:</P><P></P><P>Difference&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P></P><P>Any ideas on how to do this?</P></BODY></HTML> Tue, 29 May 2012 14:36:13 GMT https://community.qlik.com/t5/QlikView/Difference-in-Pivot-Chart/m-p/372580#M138523 danielact 2012-05-29T14:36:13Z