topic Re: ORACLE- LAG LEAD FUNCTIONS IN QLIKVIEW in QlikView https://community.qlik.com/t5/QlikView/ORACLE-LAG-LEAD-FUNCTIONS-IN-QLIKVIEW/m-p/1421240#M803319 <HTML><HEAD></HEAD><BODY><P>Here we go <A href="https://community.qlik.com/qlik-blogpost/3048">Peek() vs Previous() – When to Use Each</A></P></BODY></HTML> Mon, 06 Nov 2017 14:15:46 GMT Anil_Babu_Samineni 2017-11-06T14:15:46Z ORACLE- LAG LEAD FUNCTIONS IN QLIKVIEW https://community.qlik.com/t5/QlikView/ORACLE-LAG-LEAD-FUNCTIONS-IN-QLIKVIEW/m-p/1421239#M803318 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is there a way to write below mentioned Oracle Code in qlikview.</P><P></P><P>LAG(COMPLETE_DATE,1)OVER( partition by ID ORDER BY A,B_ID,&nbsp; COMPLETE_DATE)</P><P></P><P>LEAD(COMPLETE_DATE,1)OVER(partition by ID ORDER BY A,B_ID,&nbsp; COMPLETE_DATE)</P><P></P><P>Thanks in Advance.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/ORACLE-LAG-LEAD-FUNCTIONS-IN-QLIKVIEW/m-p/1421239#M803318 SK28 2020-11-25T16:16:04Z Re: ORACLE- LAG LEAD FUNCTIONS IN QLIKVIEW https://community.qlik.com/t5/QlikView/ORACLE-LAG-LEAD-FUNCTIONS-IN-QLIKVIEW/m-p/1421240#M803319 <HTML><HEAD></HEAD><BODY><P>Here we go <A href="https://community.qlik.com/qlik-blogpost/3048">Peek() vs Previous() – When to Use Each</A></P></BODY></HTML> Mon, 06 Nov 2017 14:15:46 GMT https://community.qlik.com/t5/QlikView/ORACLE-LAG-LEAD-FUNCTIONS-IN-QLIKVIEW/m-p/1421240#M803319 Anil_Babu_Samineni 2017-11-06T14:15:46Z Re: ORACLE- LAG LEAD FUNCTIONS IN QLIKVIEW https://community.qlik.com/t5/QlikView/ORACLE-LAG-LEAD-FUNCTIONS-IN-QLIKVIEW/m-p/1421241#M803320 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/121785">How to get LEAD &amp;amp; LAG function in Qlikview</A></P></BODY></HTML> Mon, 06 Nov 2017 14:17:59 GMT https://community.qlik.com/t5/QlikView/ORACLE-LAG-LEAD-FUNCTIONS-IN-QLIKVIEW/m-p/1421241#M803320 jpenuliar 2017-11-06T14:17:59Z