convert the below Teradata script into Qlik script.

[Qlikbuddy]

Convert the below tera data Query into the Qlik Script.

CREATE VOLATILE MULTISET TABLE funnel AS (

SELECT * FROM dev_bpl.funnel

QUALIFY ROW_NUMBER() OVER (PARTITION BY Event_Id ORDER BY TD_SYSFNLIB.NVL (order_id, 0)  DESC) = 1

) WITH DATA PRIMARY INDEX (Event_Id) ON COMMIT PRESERVE ROWS;

[anat]

you may try using Autonumber or comparing Id with previous Id.

use below links for reference.

https://community.qlik.com/t5/QlikView-App-Dev/ROW-NUMBER-OVER-PARTITION-BY-A-B-C-ordered-by-x/td-p/...

https://community.qlik.com/t5/App-Development/Row-number-over-partition-by/td-p/2112712

https://community.qlik.com/t5/Visualization-and-Usability/SQL-ROW-NUMBER-OVER-PARTITION-BY-ORDER-BY-...

[Qlikbuddy]

Would be great, if some one convert it for me in entire Qlik script. some how i am not able to convert it.