Discussion Board for collaboration related to QlikView App Development.
What does the below script does with previous function?
LOAD * Resident test_temp
, Order_date desc
It loads each row where ID is different from the previous row when sorted by code and order_date descending.
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.