Quick easy question! ... well i think

[employe4_2]

Hi,

i want to get some date when a value from a variable change.

i go this table 

and in the first line where the value change from 0 to 5 i want to keep the date value. i was going in this exercice like" yeah ez af"  but comparing with a value from an other timeline bug my mind ...

anyone got an hint ?

thx

[dplr-rn]

Not clear what you are trying to achieve. but i understand you want to compare current row with row before somehow.

Use above function

https://community.qlik.com/t5/QlikView-Documents/Missing-Manual-Above-and-Below/ta-p/1481948

[chriscammers · Accepted solution]

If you want to calculate this in your load script then you'd want to think about the functions peek() and previous()

https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordFun...

https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordFun...

Then if you are thinking about just doing it within the chart then you would want to think about the above() function.

https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterReco...