Need help on converting Sql syntax to Qlik

[chinnu123]

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

[prma7799]

Please check this

ROW_NUMBER() OVER(PARTITION BY PostalCode ORDER BY SalesYTD DESC) AS 'Row Number'

LEAD(...) OVER (PARTITION BY ... ORDER BY ...) | Qlik Community

[Anil_Babu_Samineni]

Don't create duplicate Need help on converting SQl code to qlik code

[woshua5550]

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