topic Need help on converting SQl code to qlik code in QlikView https://community.qlik.com/t5/QlikView/Need-help-on-converting-SQl-code-to-qlik-code/m-p/1388366#M802625 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>Please help in converting below sql code to qlik</P><P></P><P>select Status, </P><P>lag(Status) over (partition by Incident_Id order by ROW_UPDATE_DATE) previous_Status</P><P>ROW_UPDATE_DATE</P><P>from TableA </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT chinnu123 2020-11-25T16:16:04Z Need help on converting SQl code to qlik code https://community.qlik.com/t5/QlikView/Need-help-on-converting-SQl-code-to-qlik-code/m-p/1388366#M802625 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>Please help in converting below sql code to qlik</P><P></P><P>select Status, </P><P>lag(Status) over (partition by Incident_Id order by ROW_UPDATE_DATE) previous_Status</P><P>ROW_UPDATE_DATE</P><P>from TableA </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Need-help-on-converting-SQl-code-to-qlik-code/m-p/1388366#M802625 chinnu123 2020-11-25T16:16:04Z Re: Need help on converting SQl code to qlik code https://community.qlik.com/t5/QlikView/Need-help-on-converting-SQl-code-to-qlik-code/m-p/1388367#M802626 <HTML><HEAD></HEAD><BODY><P>Look for <A href="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/InterRecordFunctions/Previous.htm" title="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/InterRecordFunctions/Previous.htm">Previous ‒ QlikView</A></P></BODY></HTML> Tue, 14 Nov 2017 13:48:24 GMT https://community.qlik.com/t5/QlikView/Need-help-on-converting-SQl-code-to-qlik-code/m-p/1388367#M802626 Anil_Babu_Samineni 2017-11-14T13:48:24Z Re: Need help on converting SQl code to qlik code https://community.qlik.com/t5/QlikView/Need-help-on-converting-SQl-code-to-qlik-code/m-p/1388368#M802627 <HTML><HEAD></HEAD><BODY><P>Hi Anil,</P><P></P><P>Thanks for your quick reply,</P><P></P><P>I tried by using previous but I don't know I am missing something So can you please share the&nbsp; expresion by using preivious</P><P></P><P>Thanks,</P><P>Chinnu</P></BODY></HTML> Tue, 14 Nov 2017 13:51:30 GMT https://community.qlik.com/t5/QlikView/Need-help-on-converting-SQl-code-to-qlik-code/m-p/1388368#M802627 chinnu123 2017-11-14T13:51:30Z Re: Need help on converting SQl code to qlik code https://community.qlik.com/t5/QlikView/Need-help-on-converting-SQl-code-to-qlik-code/m-p/1388369#M802628 <HTML><HEAD></HEAD><BODY><P>In fact, SQL also works with QIX engine. You can just copy and run. or else <A href="https://community.qlik.com/qlik-blogpost/3048">Peek() vs Previous() – When to Use Each</A></P></BODY></HTML> Tue, 14 Nov 2017 13:58:04 GMT https://community.qlik.com/t5/QlikView/Need-help-on-converting-SQl-code-to-qlik-code/m-p/1388369#M802628 Anil_Babu_Samineni 2017-11-14T13:58:04Z