Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Please help in converting below sql code to qlik
select Status,
lag(Status) over (partition by Incident_Id order by ROW_UPDATE_DATE) previous_Status
ROW_UPDATE_DATE
from TableA
Look for Previous ‒ QlikView
Hi Anil,
Thanks for your quick reply,
I tried by using previous but I don't know I am missing something So can you please share the expresion by using preivious
Thanks,
Chinnu
In fact, SQL also works with QIX engine. You can just copy and run. or else Peek() vs Previous() – When to Use Each