topic above function in QlikView

above function

Mon, 28 Jan 2013 12:13:20 GMT

I'm using the above function to calculate a % change so

(

Column(5) - Above(Column(5)))

but I now want to calculate the % change from 3 years ago so I need something like 3 rows above - how do I write this expression?

Thanks

Mon, 28 Jan 2013 12:34:11 GMT

try this : Column(5) - Above(Column(5),3)

Mon, 28 Jan 2013 13:09:48 GMT

that works

thank you