topic Show difference in line chart in QlikView https://community.qlik.com/t5/QlikView/Show-difference-in-line-chart/m-p/1047161#M925865 <HTML><HEAD></HEAD><BODY><P>I have below data set. I want to calculate the differance and show that in line chart</P><P></P><P>My Data set as follow</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="142"><TBODY><TR><TD height="20" width="78">Month</TD><TD width="64">Sales</TD></TR><TR><TD class="xl64" height="20">2014-dec</TD><TD align="right">1000</TD></TR><TR><TD class="xl63" height="20">2015-jan</TD><TD align="right">1500</TD></TR><TR><TD class="xl63" height="20">2015-feb</TD><TD align="right">2000</TD></TR><TR><TD class="xl63" height="20">2015-march</TD><TD align="right">750</TD></TR><TR><TD class="xl63" height="20">2015-april</TD><TD align="right">1586</TD></TR><TR><TD class="xl63" height="20">2015-may</TD><TD align="right">2258</TD></TR><TR><TD class="xl63" height="20">2015-june</TD><TD align="right">4415</TD></TR><TR><TD class="xl63" height="20">2015-july</TD><TD align="right">2133</TD></TR><TR><TD class="xl63" height="20">2015-aug</TD><TD align="right">9946</TD></TR><TR><TD class="xl63" height="20">2015-sep</TD><TD align="right">1334</TD></TR><TR><TD class="xl63" height="20">2015-oct</TD><TD align="right">1587</TD></TR><TR><TD class="xl63" height="20">2015-now</TD><TD align="right">2145</TD></TR><TR><TD class="xl63" height="20">2015-dec</TD><TD align="right">987</TD></TR><TR><TD class="xl63" height="20">2016-jan</TD><TD align="right"><P>2456</P></TD></TR></TBODY></TABLE><P></P><P>I want to show </P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="136"><TBODY><TR><TD height="20" width="72">jan-dec</TD><TD align="right" width="64">500</TD></TR><TR><TD height="20">Jan - feb</TD><TD align="right">500</TD></TR><TR><TD height="20">feb -march</TD><TD align="right">-1250</TD></TR><TR><TD height="20">march - apr</TD><TD align="right">836</TD></TR><TR><TD height="20">apr -may</TD><TD align="right">672</TD></TR><TR><TD height="20">may -june</TD><TD align="right">2157</TD></TR></TBODY></TABLE><P>etc in line chart. for last 12 months</P><P></P><P>is it possible</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT anuradhaa 2020-11-25T16:16:04Z Show difference in line chart https://community.qlik.com/t5/QlikView/Show-difference-in-line-chart/m-p/1047161#M925865 <HTML><HEAD></HEAD><BODY><P>I have below data set. I want to calculate the differance and show that in line chart</P><P></P><P>My Data set as follow</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="142"><TBODY><TR><TD height="20" width="78">Month</TD><TD width="64">Sales</TD></TR><TR><TD class="xl64" height="20">2014-dec</TD><TD align="right">1000</TD></TR><TR><TD class="xl63" height="20">2015-jan</TD><TD align="right">1500</TD></TR><TR><TD class="xl63" height="20">2015-feb</TD><TD align="right">2000</TD></TR><TR><TD class="xl63" height="20">2015-march</TD><TD align="right">750</TD></TR><TR><TD class="xl63" height="20">2015-april</TD><TD align="right">1586</TD></TR><TR><TD class="xl63" height="20">2015-may</TD><TD align="right">2258</TD></TR><TR><TD class="xl63" height="20">2015-june</TD><TD align="right">4415</TD></TR><TR><TD class="xl63" height="20">2015-july</TD><TD align="right">2133</TD></TR><TR><TD class="xl63" height="20">2015-aug</TD><TD align="right">9946</TD></TR><TR><TD class="xl63" height="20">2015-sep</TD><TD align="right">1334</TD></TR><TR><TD class="xl63" height="20">2015-oct</TD><TD align="right">1587</TD></TR><TR><TD class="xl63" height="20">2015-now</TD><TD align="right">2145</TD></TR><TR><TD class="xl63" height="20">2015-dec</TD><TD align="right">987</TD></TR><TR><TD class="xl63" height="20">2016-jan</TD><TD align="right"><P>2456</P></TD></TR></TBODY></TABLE><P></P><P>I want to show </P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="136"><TBODY><TR><TD height="20" width="72">jan-dec</TD><TD align="right" width="64">500</TD></TR><TR><TD height="20">Jan - feb</TD><TD align="right">500</TD></TR><TR><TD height="20">feb -march</TD><TD align="right">-1250</TD></TR><TR><TD height="20">march - apr</TD><TD align="right">836</TD></TR><TR><TD height="20">apr -may</TD><TD align="right">672</TD></TR><TR><TD height="20">may -june</TD><TD align="right">2157</TD></TR></TBODY></TABLE><P>etc in line chart. for last 12 months</P><P></P><P>is it possible</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Show-difference-in-line-chart/m-p/1047161#M925865 anuradhaa 2020-11-25T16:16:04Z Re: Show difference in line chart https://community.qlik.com/t5/QlikView/Show-difference-in-line-chart/m-p/1047162#M925866 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P>=Sum(Sales) -<STRONG>Above</STRONG>(Sum(Sales))</P><P></P><P>as expression with dimension Month</P></BODY></HTML> Mon, 04 Apr 2016 11:05:10 GMT https://community.qlik.com/t5/QlikView/Show-difference-in-line-chart/m-p/1047162#M925866 swuehl 2016-04-04T11:05:10Z Re: Show difference in line chart https://community.qlik.com/t5/QlikView/Show-difference-in-line-chart/m-p/1047163#M925867 <HTML><HEAD></HEAD><BODY><P>May be like the attached</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/120396_Capture.PNG" style="height: 212px; width: 620px;" /></P></BODY></HTML> Mon, 04 Apr 2016 11:07:32 GMT https://community.qlik.com/t5/QlikView/Show-difference-in-line-chart/m-p/1047163#M925867 sunny_talwar 2016-04-04T11:07:32Z