topic Re: Bar chart with difference in result in QlikView https://community.qlik.com/t5/QlikView/Bar-chart-with-difference-in-result/m-p/838002#M294637 <HTML><HEAD></HEAD><BODY><P>Here is a sample qvw prepared from the data you gave and expression <A _jive_internal="true" href="https://community.qlik.com/people/swuehl">swuehl</A>‌ suggested.</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/91099_Capture.PNG" style="height: 390px; width: 620px;" /></P></BODY></HTML> Sun, 28 Jun 2015 12:47:50 GMT sunny_talwar 2015-06-28T12:47:50Z Bar chart with difference in result https://community.qlik.com/t5/QlikView/Bar-chart-with-difference-in-result/m-p/838000#M294635 <HTML><HEAD></HEAD><BODY><P>hi</P><P>i have a table like below</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Year</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Value</STRONG></TH></TR><TR><TD style="padding: 2px;">2010</TD><TD style="padding: 2px;">10</TD></TR><TR><TD style="padding: 2px;">2011</TD><TD style="padding: 2px;">15</TD></TR><TR><TD style="padding: 2px;">2012</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">2013</TD><TD style="padding: 2px;">8</TD></TR><TR><TD style="padding: 2px;">2014</TD><TD style="padding: 2px;">7</TD></TR></TBODY></TABLE><P>i need to have a bar chart with dimension of year and difference of values of two year</P><P>it means like this:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>year</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>new value (value of current year - value of past year)</STRONG></TH></TR><TR><TD style="padding: 2px;">2014</TD><TD style="padding: 2px;">-1</TD></TR><TR><TD style="padding: 2px;">2013</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">2012</TD><TD style="padding: 2px;">-10</TD></TR><TR><TD style="padding: 2px;">2011</TD><TD style="padding: 2px;">5</TD></TR></TBODY></TABLE><P>what should i do in qlikview to have this chart?</P></BODY></HTML> Sun, 28 Jun 2015 12:19:06 GMT https://community.qlik.com/t5/QlikView/Bar-chart-with-difference-in-result/m-p/838000#M294635 omid5ive 2015-06-28T12:19:06Z Re: Bar chart with difference in result https://community.qlik.com/t5/QlikView/Bar-chart-with-difference-in-result/m-p/838001#M294636 <HTML><HEAD></HEAD><BODY><P>Try chart inter record functions, like below() or above() (depending on sort order of Year dimension):</P><P></P><P>=sum(Value) - below(sum(Value))</P></BODY></HTML> Sun, 28 Jun 2015 12:29:30 GMT https://community.qlik.com/t5/QlikView/Bar-chart-with-difference-in-result/m-p/838001#M294636 swuehl 2015-06-28T12:29:30Z Re: Bar chart with difference in result https://community.qlik.com/t5/QlikView/Bar-chart-with-difference-in-result/m-p/838002#M294637 <HTML><HEAD></HEAD><BODY><P>Here is a sample qvw prepared from the data you gave and expression <A _jive_internal="true" href="https://community.qlik.com/people/swuehl">swuehl</A>‌ suggested.</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/91099_Capture.PNG" style="height: 390px; width: 620px;" /></P></BODY></HTML> Sun, 28 Jun 2015 12:47:50 GMT https://community.qlik.com/t5/QlikView/Bar-chart-with-difference-in-result/m-p/838002#M294637 sunny_talwar 2015-06-28T12:47:50Z Re: Bar chart with difference in result https://community.qlik.com/t5/QlikView/Bar-chart-with-difference-in-result/m-p/838003#M294638 <HTML><HEAD></HEAD><BODY><P>thank you</P></BODY></HTML> Sun, 28 Jun 2015 15:01:23 GMT https://community.qlik.com/t5/QlikView/Bar-chart-with-difference-in-result/m-p/838003#M294638 omid5ive 2015-06-28T15:01:23Z Re: Bar chart with difference in result https://community.qlik.com/t5/QlikView/Bar-chart-with-difference-in-result/m-p/838004#M294639 <HTML><HEAD></HEAD><BODY><P>thank you</P></BODY></HTML> Sun, 28 Jun 2015 15:01:38 GMT https://community.qlik.com/t5/QlikView/Bar-chart-with-difference-in-result/m-p/838004#M294639 omid5ive 2015-06-28T15:01:38Z Re: Bar chart with difference in result https://community.qlik.com/t5/QlikView/Bar-chart-with-difference-in-result/m-p/838005#M294640 <HTML><HEAD></HEAD><BODY><P>No problem <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Glad we were able to help.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Sun, 28 Jun 2015 15:52:31 GMT https://community.qlik.com/t5/QlikView/Bar-chart-with-difference-in-result/m-p/838005#M294640 sunny_talwar 2015-06-28T15:52:31Z