Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
wdchristensen
Specialist
Specialist

What is the qlik sense CHART function equivalent to LEAD and LAG in TSQL?

What is the qlik sense CHART function equivalent to LEAD and LAG in TSQL?

Previous() & Peek() are for load scripts only. 

I was thinking maybe Before / After but it looks like those are only for Pivot Tables and I am looking for something to work in a straight table to compare against the previous (sorted) record. Any thoughts? 

Labels (4)
2 Replies
dplr-rn
Partner - Master III
Partner - Master III

Channa
Specialist III
Specialist III

try Above() to get top row 

generally used in rangesum

Channa