Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
skkrishna
Contributor III
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
Anil_Babu_Samineni

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
Anil_Babu_Samineni

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

jpenuliar
Partner
Partner