Solved: ORACLE- LAG LEAD FUNCTIONS IN QLIKVIEW - Qlik Community

SK28 · ‎2017-11-06

Hi,

Is there a way to write below mentioned Oracle Code in qlikview.

LAG(COMPLETE_DATE,1)OVER( partition by ID ORDER BY A,B_ID, COMPLETE_DATE)

LEAD(COMPLETE_DATE,1)OVER(partition by ID ORDER BY A,B_ID, COMPLETE_DATE)

Thanks in Advance.

Anil_Babu_Samineni · ‎2017-11-06

Here we go Peek() vs Previous() – When to Use Each

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

Anil_Babu_Samineni · ‎2017-11-06

Here we go Peek() vs Previous() – When to Use Each

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

jpenuliar · ‎2017-11-06

How to get LEAD & LAG function in Qlikview