Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
SK28
Creator II
Creator II
‎2017-11-06 09:10 AM

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.

Labels (1)
Labels
2,134 Views
0 Likes
1 Solution

Accepted Solutions
Anil_Babu_Samineni
MVP
MVP
‎2017-11-06 09:15 AM

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

1,928 Views
0 Likes
2 Replies
Anil_Babu_Samineni
MVP
MVP
‎2017-11-06 09:15 AM

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
1,929 Views
0 Likes
jpenuliar
Partner - Specialist III
Partner - Specialist III
‎2017-11-06 09:17 AM

How to get LEAD & LAG function in Qlikview

1,928 Views
0 Likes