https://community.qlik.com/t5/QlikView/Sql-equivalent-of-qlikview-script/m-p/1642847#M730810 <P>Check lag and lead functions in sql.</P><P>lag for previous row.</P><P><A href="https://docs.microsoft.com/de-de/sql/t-sql/functions/lag-transact-sql?view=sql-server-ver15" target="_blank">https://docs.microsoft.com/de-de/sql/t-sql/functions/lag-transact-sql?view=sql-server-ver15</A></P><P>lead for next row.</P><P><A href="https://docs.microsoft.com/de-de/sql/t-sql/functions/lead-transact-sql?view=sql-server-ver15" target="_blank">https://docs.microsoft.com/de-de/sql/t-sql/functions/lead-transact-sql?view=sql-server-ver15</A></P><P>regards</P><P>tim</P> Tue, 05 Nov 2019 07:27:13 GMT zhadrakas 2019-11-05T07:27:13Z https://community.qlik.com/t5/QlikView/Sql-equivalent-of-qlikview-script/m-p/1642841#M730809 <P>Hi all,</P><P>I want to know how to write the below statement in SQL. Could anyone help me with this please?</P><P>if([Customer Number]=Previous([Customer Number]),Peek('Sequence')+1,1) as [Sequence]</P><P>Thanks in advance</P><P>Anusha</P> Sat, 16 Nov 2024 02:02:36 GMT https://community.qlik.com/t5/QlikView/Sql-equivalent-of-qlikview-script/m-p/1642841#M730809 anushahegde 2024-11-16T02:02:36Z https://community.qlik.com/t5/QlikView/Sql-equivalent-of-qlikview-script/m-p/1642847#M730810 <P>Check lag and lead functions in sql.</P><P>lag for previous row.</P><P><A href="https://docs.microsoft.com/de-de/sql/t-sql/functions/lag-transact-sql?view=sql-server-ver15" target="_blank">https://docs.microsoft.com/de-de/sql/t-sql/functions/lag-transact-sql?view=sql-server-ver15</A></P><P>lead for next row.</P><P><A href="https://docs.microsoft.com/de-de/sql/t-sql/functions/lead-transact-sql?view=sql-server-ver15" target="_blank">https://docs.microsoft.com/de-de/sql/t-sql/functions/lead-transact-sql?view=sql-server-ver15</A></P><P>regards</P><P>tim</P> Tue, 05 Nov 2019 07:27:13 GMT https://community.qlik.com/t5/QlikView/Sql-equivalent-of-qlikview-script/m-p/1642847#M730810 zhadrakas 2019-11-05T07:27:13Z