Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
smitaranikr04
Contributor

Previous in script

Hey Guys,

What does  the below script does with previous function?

test:

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.

Highlighted
balabhaskarqlik
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.