topic Straight Table Difference between columns in QlikView

Straight Table Difference between columns

Fri, 10 Feb 2012 16:59:43 GMT

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?

Straight Table Difference between columns

swuehl — Fri, 10 Feb 2012 17:09:02 GMT

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

Straight Table Difference between columns

Fri, 10 Feb 2012 17:21:09 GMT

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.