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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Anil_Babu_Samineni · ‎2017-11-06

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

jpenuliar · ‎2017-11-06

How to get LEAD & LAG function in Qlikview