Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Quick easy question! ... well i think

Hi,

 

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

i go this table 

2019-09-10_15h28_11.pngand 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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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...

 

 

View solution in original post

2 Replies
Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

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...

 

 

View solution in original post