topic Re: How to use lag function in qlikview in QlikView https://community.qlik.com/t5/QlikView/How-to-use-lag-function-in-qlikview/m-p/1400418#M817739 <HTML><HEAD></HEAD><BODY><P>I think Qlik equivalent of lag might be</P><P><A href="https://community.qlik.com/docs/DOC-4073">Peek() vs Previous() – When to Use Each</A></P></BODY></HTML> Tue, 29 Aug 2017 11:21:38 GMT sunny_talwar 2017-08-29T11:21:38Z How to use lag function in qlikview https://community.qlik.com/t5/QlikView/How-to-use-lag-function-in-qlikview/m-p/1400417#M817738 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P></P><P>Below expression I need to write in qlikview in backend script. Can anyone please help me in this</P><P></P><P>Lag(appl_id) over (partition by key order by open date&nbsp; asc) prev_id.</P><P></P><P>Thanks in advance,</P><P></P><P>Thanks,</P><P>Chinnu.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-use-lag-function-in-qlikview/m-p/1400417#M817738 chinnu123 2020-11-25T16:16:04Z Re: How to use lag function in qlikview https://community.qlik.com/t5/QlikView/How-to-use-lag-function-in-qlikview/m-p/1400418#M817739 <HTML><HEAD></HEAD><BODY><P>I think Qlik equivalent of lag might be</P><P><A href="https://community.qlik.com/docs/DOC-4073">Peek() vs Previous() – When to Use Each</A></P></BODY></HTML> Tue, 29 Aug 2017 11:21:38 GMT https://community.qlik.com/t5/QlikView/How-to-use-lag-function-in-qlikview/m-p/1400418#M817739 sunny_talwar 2017-08-29T11:21:38Z Re: How to use lag function in qlikview https://community.qlik.com/t5/QlikView/How-to-use-lag-function-in-qlikview/m-p/1400419#M817740 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>Thanks for your reply,</P><P></P><P>Can you please tell me which one I can use for above expression</P><P></P><P>Thanks,</P><P>Chinnu.</P></BODY></HTML> Tue, 29 Aug 2017 11:26:20 GMT https://community.qlik.com/t5/QlikView/How-to-use-lag-function-in-qlikview/m-p/1400419#M817740 chinnu123 2017-08-29T11:26:20Z Re: How to use lag function in qlikview https://community.qlik.com/t5/QlikView/How-to-use-lag-function-in-qlikview/m-p/1400420#M817741 <HTML><HEAD></HEAD><BODY><P>I am not 100% sure what your SQL is doing... but in general both Previous and Peek look at the values in the previous rows while loading the data... may be share input and output based on your SQL and we can help you with the QlikView script</P></BODY></HTML> Tue, 29 Aug 2017 11:37:33 GMT https://community.qlik.com/t5/QlikView/How-to-use-lag-function-in-qlikview/m-p/1400420#M817741 sunny_talwar 2017-08-29T11:37:33Z