How to use lag function in qlikview

[chinnu123]

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.

[sunny_talwar]

I think Qlik equivalent of lag might be

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

[chinnu123]

Hi Sunny,

Thanks for your reply,

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

Thanks,

Chinnu.

[sunny_talwar]

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