Straight Table Difference between columns

[#1]

Hi all,

I have the following straight Table, with a dimension of year, and an expression of incoming and i want to know how to calculate the difference between years automatically.

How do i do that?

	2010	2011	2012
Incoming	300	500	900
Difference	0	200	400

any clues?

[swuehl · Accepted solution]

Try chart inter record functions, namely above() {but have a look at the others, too}.

When using a straight table, try

= sum(Incoming) - above(sum(Incoming))

When using in a pivot, you need to take care of the expression and dimension orientation, so if pivoted to the left, try

= sum(Incoming) - before(sum(Incoming))

Hope this helps,

Stefan

[#3]

Thanks a lot Stefan.

I getting used to qlikview functions, and a tried it with above and below, but didnt work.

But with after, works fine.

Thanks again.