Discussion board where members can get started with QlikView.
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?
try this : Column(5) - Above(Column(5),3)