topic Re: Need help on converting Sql syntax to Qlik in QlikView https://community.qlik.com/t5/QlikView/Need-help-on-converting-Sql-syntax-to-Qlik/m-p/1434692#M804501 <HTML><HEAD></HEAD><BODY><P>Please check this</P><P></P><P><A href="https://community.qlik.com/thread/3093">ROW_NUMBER() OVER(PARTITION BY PostalCode ORDER BY SalesYTD DESC) AS 'Row Number'</A></P><P><A href="https://community.qlikview.com/thread/208361" title="https://community.qlikview.com/thread/208361">LEAD(...) OVER (PARTITION BY ... ORDER BY ...) | Qlik Community</A></P></BODY></HTML> Wed, 08 Nov 2017 06:59:27 GMT prma7799 2017-11-08T06:59:27Z Need help on converting Sql syntax to Qlik https://community.qlik.com/t5/QlikView/Need-help-on-converting-Sql-syntax-to-Qlik/m-p/1434691#M804500 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>Can any one please help on converting below sql syntax to qlikview</P><P></P><P>lag(level_Id) over (partition by Incident_Id order by UPDATED_DATE) previous_level_ID</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Need-help-on-converting-Sql-syntax-to-Qlik/m-p/1434691#M804500 chinnu123 2020-11-25T16:16:04Z Re: Need help on converting Sql syntax to Qlik https://community.qlik.com/t5/QlikView/Need-help-on-converting-Sql-syntax-to-Qlik/m-p/1434692#M804501 <HTML><HEAD></HEAD><BODY><P>Please check this</P><P></P><P><A href="https://community.qlik.com/thread/3093">ROW_NUMBER() OVER(PARTITION BY PostalCode ORDER BY SalesYTD DESC) AS 'Row Number'</A></P><P><A href="https://community.qlikview.com/thread/208361" title="https://community.qlikview.com/thread/208361">LEAD(...) OVER (PARTITION BY ... ORDER BY ...) | Qlik Community</A></P></BODY></HTML> Wed, 08 Nov 2017 06:59:27 GMT https://community.qlik.com/t5/QlikView/Need-help-on-converting-Sql-syntax-to-Qlik/m-p/1434692#M804501 prma7799 2017-11-08T06:59:27Z Re: Need help on converting Sql syntax to Qlik https://community.qlik.com/t5/QlikView/Need-help-on-converting-Sql-syntax-to-Qlik/m-p/1434693#M804502 <HTML><HEAD></HEAD><BODY><P>Don't create duplicate <A href="https://community.qlik.com/message/1381639">Need help on converting SQl code to qlik code</A></P></BODY></HTML> Wed, 15 Nov 2017 07:29:01 GMT https://community.qlik.com/t5/QlikView/Need-help-on-converting-Sql-syntax-to-Qlik/m-p/1434693#M804502 Anil_Babu_Samineni 2017-11-15T07:29:01Z Re: Need help on converting Sql syntax to Qlik https://community.qlik.com/t5/QlikView/Need-help-on-converting-Sql-syntax-to-Qlik/m-p/1434694#M804503 <HTML><HEAD></HEAD><BODY><P>Maybe like this:</P><P><BR />LOAD *,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF(Incident_Id=Previous(Incident_Id),Previous(level_Id),Null()) as previous_level_ID<BR />From &lt;Your table name&gt;</P><P>Order By Incident_Id,UPDATED_DATE ;</P><P></P><P>Previous() function in QV script is equivalent to lag() function in SQL</P></BODY></HTML> Wed, 15 Nov 2017 09:59:00 GMT https://community.qlik.com/t5/QlikView/Need-help-on-converting-Sql-syntax-to-Qlik/m-p/1434694#M804503 woshua5550 2017-11-15T09:59:00Z