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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-02-08 03:21 PM

Can you simulate copying a cell expression in excel or update a variable in a chart expression?

Can you update a variable in a chart expression?  I am trying to build a simple forward looking planning curve and base future values on past values.  I am using inter-record functions.  However, after one period in the future, the ABOVE function is no longer giving me what is in the row above.

For example, I am using the following expression:

=if(max(retrieveddate) < today(),rangeavg(ABOVE($(vNetChangeOpen),0,4)), ABOVE($(vAvgRollingChange),1))

Basically this checks if I am in the future or not. 

If in the past, do a calculation based on average or prior 4 rows for a variable.

If in the future, I want to use the last value that was stored in a variable so look in prior row using ABOVE. 

Works for first future row, then does not.  How would I keep repeating the same value when in the future?

436 Views
0 Likes
0 Replies