Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

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.