topic Re: distinct field with multiple previous rows up in QlikView https://community.qlik.com/t5/QlikView/distinct-field-with-multiple-previous-rows-up/m-p/1304174#M821790 <HTML><HEAD></HEAD><BODY><P>Peek(Date,-9) as Prev_Date</P></BODY></HTML> Thu, 27 Jul 2017 22:18:33 GMT MarcoWedel 2017-07-27T22:18:33Z distinct field with multiple previous rows up https://community.qlik.com/t5/QlikView/distinct-field-with-multiple-previous-rows-up/m-p/1304172#M821788 <HTML><HEAD></HEAD><BODY><P>This is probably a simple question due to being a beginner....but I want to identify a field that is more rows up than just previous in the load script. I prefer this to be named to a new field in the load script due to sorting issues, but open to ideas within a straight table as well.</P><P></P><P>I have ordered my table by a "Date" field and I want to identify the Date that exists 9 rows up in the table and call it "Prev_Date".</P><P></P><P>I tried the previous function, but then realized that I have multiple of the same date. So I will need to make the Date field distinct and then look 9 dates up. Any ideas?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/distinct-field-with-multiple-previous-rows-up/m-p/1304172#M821788 sarahshong 2020-11-25T16:16:04Z Re: distinct field with multiple previous rows up https://community.qlik.com/t5/QlikView/distinct-field-with-multiple-previous-rows-up/m-p/1304173#M821789 <HTML><HEAD></HEAD><BODY><P>Sarah,</P><P></P><P>Could you provide some sample data, with expected outcome?</P><P></P><P>Thanks</P><P>Oscar</P></BODY></HTML> Thu, 27 Jul 2017 18:13:04 GMT https://community.qlik.com/t5/QlikView/distinct-field-with-multiple-previous-rows-up/m-p/1304173#M821789 oscar_ortiz 2017-07-27T18:13:04Z Re: distinct field with multiple previous rows up https://community.qlik.com/t5/QlikView/distinct-field-with-multiple-previous-rows-up/m-p/1304174#M821790 <HTML><HEAD></HEAD><BODY><P>Peek(Date,-9) as Prev_Date</P></BODY></HTML> Thu, 27 Jul 2017 22:18:33 GMT https://community.qlik.com/t5/QlikView/distinct-field-with-multiple-previous-rows-up/m-p/1304174#M821790 MarcoWedel 2017-07-27T22:18:33Z