Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

above function

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

2 Replies
Not applicable
Author

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

Not applicable
Author

that works

thank you