Discussion board where members can get started with QlikView.
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,
I think Qlik equivalent of lag might be
Peek() vs Previous() – When to Use Each
Thanks for your reply,
Can you please tell me which one I can use for above expression
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