Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
did you try above function?
check below
https://community.qlik.com/t5/QlikView-Documents/Missing-Manual-Above-and-Below/ta-p/1481948
try Above() to get top row
generally used in rangesum