Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I think Qlik equivalent of lag might be
Hi Sunny,
Thanks for your reply,
Can you please tell me which one I can use for above expression
Thanks,
Chinnu.
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