Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

How to use lag function in qlikview

Hi Team,

Below expression I need to write in qlikview in backend script. Can anyone please help me in this

Lag(appl_id) over (partition by key order by open date  asc) prev_id.

Thanks in advance,

Thanks,

Chinnu.

3 Replies
Highlighted

I think Qlik equivalent of lag might be

Peek() vs Previous() – When to Use Each

Highlighted
Creator
Creator

Hi Sunny,

Thanks for your reply,

Can you please tell me which one I can use for above expression

Thanks,

Chinnu.

Highlighted

I am not 100% sure what your SQL is doing... but in general both Previous and Peek look at the values in the previous rows while loading the data... may be share input and output based on your SQL and we can help you with the QlikView script