Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor III

ORACLE- LAG LEAD FUNCTIONS IN QLIKVIEW

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.

1 Solution

Accepted Solutions
Highlighted

Re: ORACLE- LAG LEAD FUNCTIONS IN QLIKVIEW

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

2 Replies
Highlighted

Re: ORACLE- LAG LEAD FUNCTIONS IN QLIKVIEW

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

Highlighted
Partner
Partner

Re: ORACLE- LAG LEAD FUNCTIONS IN QLIKVIEW