Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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?

Tags (1)