topic how to insert difference in the same chart in QlikView https://community.qlik.com/t5/QlikView/how-to-insert-difference-in-the-same-chart/m-p/359078#M576086 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P>pretty sure (or hoping) that there is a simple answer, but I was not able to track it in other posts. I have a set of sales data, one of the column is YEAR, I have a pivot chart showing sales of this and previous year and I'd like to insert a third column with the difference, I tried multiple ways (wih label for toals) but none is giving the result wanted, or I'm doing something wrong. Now I'm using a second chart, but it's not handy.</P><P>Thank you in advance</P><P>M.</P></BODY></HTML> Thu, 19 Apr 2012 09:47:39 GMT 2012-04-19T09:47:39Z how to insert difference in the same chart https://community.qlik.com/t5/QlikView/how-to-insert-difference-in-the-same-chart/m-p/359078#M576086 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P>pretty sure (or hoping) that there is a simple answer, but I was not able to track it in other posts. I have a set of sales data, one of the column is YEAR, I have a pivot chart showing sales of this and previous year and I'd like to insert a third column with the difference, I tried multiple ways (wih label for toals) but none is giving the result wanted, or I'm doing something wrong. Now I'm using a second chart, but it's not handy.</P><P>Thank you in advance</P><P>M.</P></BODY></HTML> Thu, 19 Apr 2012 09:47:39 GMT https://community.qlik.com/t5/QlikView/how-to-insert-difference-in-the-same-chart/m-p/359078#M576086 2012-04-19T09:47:39Z how to insert difference in the same chart https://community.qlik.com/t5/QlikView/how-to-insert-difference-in-the-same-chart/m-p/359079#M576087 <HTML><HEAD></HEAD><BODY><P>Did you try:</P><P></P><P>Column(1) - Column(2)</P><P></P><P>?</P></BODY></HTML> Thu, 19 Apr 2012 09:50:57 GMT https://community.qlik.com/t5/QlikView/how-to-insert-difference-in-the-same-chart/m-p/359079#M576087 Anonymous 2012-04-19T09:50:57Z how to insert difference in the same chart https://community.qlik.com/t5/QlikView/how-to-insert-difference-in-the-same-chart/m-p/359080#M576088 <HTML><HEAD></HEAD><BODY><P><SPAN>I found the solution (</SPAN><A class="jive-link-external-small" href="http://community.qlik.com/message/24253#24253">http://community.qlik.com/message/24253#24253</A><SPAN>) through your sugestion. Thanx</SPAN></P></BODY></HTML> Thu, 19 Apr 2012 10:34:19 GMT https://community.qlik.com/t5/QlikView/how-to-insert-difference-in-the-same-chart/m-p/359080#M576088 2012-04-19T10:34:19Z Re: how to insert difference in the same chart https://community.qlik.com/t5/QlikView/how-to-insert-difference-in-the-same-chart/m-p/359081#M576089 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; I think difference of first two expression in third column right? if right means </P><P></P><P>use the expression in third column like = column(1) - column(2). </P><P></P><P>I attached a sample file using pivot table </P><P></P><P>Regards,</P><P>Iyyappan</P></BODY></HTML> Thu, 19 Apr 2012 11:42:25 GMT https://community.qlik.com/t5/QlikView/how-to-insert-difference-in-the-same-chart/m-p/359081#M576089 v_iyyappan 2012-04-19T11:42:25Z