Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More

Previous in script

Hey Guys,

What does  the below script does with previous function?


LOAD * Resident test_temp

where Previous(ID)<>(ID)

order by

, Order_date desc

Tags (1)
2 Replies

Re: Previous in script

It loads each row where ID is different from the previous row when sorted by code and order_date descending.

Honored Contributor

Re: Previous in script

Data sorted by Code, Order_Date in descending & Comparing the Previous ID value with the Current ID. If the IDs are different it loads, else skip.