Please help in converting below sql code to qlik
lag(Status) over (partition by Incident_Id order by ROW_UPDATE_DATE) previous_Status
Look for Previous ‒ QlikView
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
In fact, SQL also works with QIX engine. You can just copy and run. or else Peek() vs Previous() – When to Use Each
Retrieving data ...