topic Re: Previous in script in QlikView https://community.qlik.com/t5/QlikView/Previous-in-script/m-p/88136#M14404 <HTML><HEAD></HEAD><BODY><P>It loads each row where ID is different from the previous row when sorted by code and order_date descending.</P></BODY></HTML> Wed, 27 Jun 2018 21:10:20 GMT MarcoWedel 2018-06-27T21:10:20Z Previous in script https://community.qlik.com/t5/QlikView/Previous-in-script/m-p/88135#M14403 <HTML><HEAD></HEAD><BODY><P>Hey Guys,</P><P></P><P>What does&nbsp; the below script does with previous function?</P><P></P><P>test:</P><P></P><P>LOAD * Resident test_temp</P><P>where Previous(ID)&lt;&gt;(ID)</P><P>order by <PRE>, Order_date desc</PRE></P></BODY></HTML> Wed, 27 Jun 2018 17:20:36 GMT https://community.qlik.com/t5/QlikView/Previous-in-script/m-p/88135#M14403 Anonymous 2018-06-27T17:20:36Z Re: Previous in script https://community.qlik.com/t5/QlikView/Previous-in-script/m-p/88136#M14404 <HTML><HEAD></HEAD><BODY><P>It loads each row where ID is different from the previous row when sorted by code and order_date descending.</P></BODY></HTML> Wed, 27 Jun 2018 21:10:20 GMT https://community.qlik.com/t5/QlikView/Previous-in-script/m-p/88136#M14404 MarcoWedel 2018-06-27T21:10:20Z Re: Previous in script https://community.qlik.com/t5/QlikView/Previous-in-script/m-p/88137#M14405 <HTML><HEAD></HEAD><BODY><P>Data sorted by Code, Order_Date in descending &amp; Comparing the Previous ID value with the Current ID. If the IDs are different it loads, else skip.</P></BODY></HTML> Thu, 28 Jun 2018 16:29:42 GMT https://community.qlik.com/t5/QlikView/Previous-in-script/m-p/88137#M14405 BalaBhaskar_Qlik 2018-06-28T16:29:42Z