Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Can any one please help on converting below sql syntax to qlikview
lag(level_Id) over (partition by Incident_Id order by UPDATED_DATE) previous_level_ID
Don't create duplicate Need help on converting SQl code to qlik code
Maybe like this:
LOAD *,
IF(Incident_Id=Previous(Incident_Id),Previous(level_Id),Null()) as previous_level_ID
From <Your table name>
Order By Incident_Id,UPDATED_DATE ;
Previous() function in QV script is equivalent to lag() function in SQL