Bar chart with difference in result

[omid5ive]

hi

i have a table like below

Year	Value
2010	10
2011	15
2012	5
2013	8
2014	7

i need to have a bar chart with dimension of year and difference of values of two year

it means like this:

year	new value (value of current year - value of past year)
2014	-1
2013	3
2012	-10
2011	5

what should i do in qlikview to have this chart?

[swuehl]

Try chart inter record functions, like below() or above() (depending on sort order of Year dimension):

=sum(Value) - below(sum(Value))

[sunny_talwar · Accepted solution]

Here is a sample qvw prepared from the data you gave and expression swuehl‌ suggested.

[omid5ive]

thank you

[omid5ive]

thank you

[sunny_talwar]

No problem

Glad we were able to help.

Best,

Sunny