https://community.qlik.com/t5/App-Development/What-is-the-qlik-sense-CHART-function-equivalent-to-LEAD-and-LAG/m-p/1589720#M43228 <P>try Above() to get top row&nbsp;</P><P>generally used in rangesum</P> Sat, 08 Jun 2019 00:10:14 GMT Channa 2019-06-08T00:10:14Z https://community.qlik.com/t5/App-Development/What-is-the-qlik-sense-CHART-function-equivalent-to-LEAD-and-LAG/m-p/1589663#M43226 <P>What is the qlik sense CHART function equivalent to LEAD and LAG in TSQL?</P><P>Previous() &amp; Peek() are for load scripts only.&nbsp;</P><P>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?&nbsp;</P> Sat, 16 Nov 2024 20:42:27 GMT https://community.qlik.com/t5/App-Development/What-is-the-qlik-sense-CHART-function-equivalent-to-LEAD-and-LAG/m-p/1589663#M43226 wdchristensen 2024-11-16T20:42:27Z https://community.qlik.com/t5/App-Development/What-is-the-qlik-sense-CHART-function-equivalent-to-LEAD-and-LAG/m-p/1589699#M43227 <P>did you try above function?</P><P>check below</P><P><A href="https://community.qlik.com/t5/QlikView-Documents/Missing-Manual-Above-and-Below/ta-p/1481948" target="_blank">https://community.qlik.com/t5/QlikView-Documents/Missing-Manual-Above-and-Below/ta-p/1481948</A></P> Fri, 07 Jun 2019 18:46:14 GMT https://community.qlik.com/t5/App-Development/What-is-the-qlik-sense-CHART-function-equivalent-to-LEAD-and-LAG/m-p/1589699#M43227 dplr-rn 2019-06-07T18:46:14Z https://community.qlik.com/t5/App-Development/What-is-the-qlik-sense-CHART-function-equivalent-to-LEAD-and-LAG/m-p/1589720#M43228 <P>try Above() to get top row&nbsp;</P><P>generally used in rangesum</P> Sat, 08 Jun 2019 00:10:14 GMT https://community.qlik.com/t5/App-Development/What-is-the-qlik-sense-CHART-function-equivalent-to-LEAD-and-LAG/m-p/1589720#M43228 Channa 2019-06-08T00:10:14Z