topic Re: Need help - peek or previous function to get last record with val for current. more info in bod in QlikView https://community.qlik.com/t5/QlikView/Need-help-peek-or-previous-function-to-get-last-record-with-val/m-p/1627044#M446179 <P>Thanks David ! Let me try</P> Mon, 23 Sep 2019 16:21:48 GMT gopal5879 2019-09-23T16:21:48Z Need help - peek or previous function to get last record with val for current. more info in body https://community.qlik.com/t5/QlikView/Need-help-peek-or-previous-function-to-get-last-record-with-val/m-p/1626975#M446171 <P>Hello folks need help, I am trying to use peek function or previous function, but not getting desired result.<BR />I need NEW_ORGANIZATION field repeated with last&nbsp; occurrence of ORGANIZATION until there is change in value.<BR />Can someone please give me hint.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><STRONG>STATUS</STRONG></TD><TD><STRONG>REFERENCEDATE</STRONG></TD><TD><STRONG>WORKITEMID</STRONG></TD><TD><STRONG>ORGANIZATION</STRONG></TD><TD>NEW_ORGANIATION</TD></TR><TR><TD>Maintenance</TD><TD>1/10/2018</TD><TD>2070400</TD><TD>A1</TD><TD>A1</TD></TR><TR><TD>Maintenance</TD><TD>1/11/2018</TD><TD>2070400</TD><TD>&nbsp;</TD><TD><STRONG>A1</STRONG></TD></TR><TR><TD>Maintenance</TD><TD>1/12/2018</TD><TD>2070400</TD><TD>&nbsp;</TD><TD><STRONG>A1</STRONG></TD></TR><TR><TD>Maintenance</TD><TD>1/13/2018</TD><TD>2070400</TD><TD>A2</TD><TD>A2</TD></TR><TR><TD>Maintenance</TD><TD>1/14/2018</TD><TD>2070400</TD><TD>&nbsp;</TD><TD><STRONG>A2</STRONG></TD></TR><TR><TD>Maintenance</TD><TD>1/15/2018</TD><TD>2070400</TD><TD>&nbsp;</TD><TD><STRONG>A2</STRONG></TD></TR><TR><TD>Maintenance</TD><TD>1/16/2018</TD><TD>2070400</TD><TD>&nbsp;</TD><TD><STRONG>A2</STRONG></TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 20:01:44 GMT https://community.qlik.com/t5/QlikView/Need-help-peek-or-previous-function-to-get-last-record-with-val/m-p/1626975#M446171 gopal5879 2024-11-16T20:01:44Z Re: Need help - peek or previous function to get last record with val for current. more info in bod https://community.qlik.com/t5/QlikView/Need-help-peek-or-previous-function-to-get-last-record-with-val/m-p/1627022#M446175 <P>This should work:</P><P>If(Len(ORGANIZATION)=0,Peek(NEW_ORGANIZATION),ORGANIZATION) as NEW_ORGANIZATION</P><P>Resident Table</P> Mon, 23 Sep 2019 15:24:41 GMT https://community.qlik.com/t5/QlikView/Need-help-peek-or-previous-function-to-get-last-record-with-val/m-p/1627022#M446175 DavidM 2019-09-23T15:24:41Z Re: Need help - peek or previous function to get last record with val for current. more info in bod https://community.qlik.com/t5/QlikView/Need-help-peek-or-previous-function-to-get-last-record-with-val/m-p/1627044#M446179 <P>Thanks David ! Let me try</P> Mon, 23 Sep 2019 16:21:48 GMT https://community.qlik.com/t5/QlikView/Need-help-peek-or-previous-function-to-get-last-record-with-val/m-p/1627044#M446179 gopal5879 2019-09-23T16:21:48Z Re: Need help - peek or previous function to get last record with val for current.info in body https://community.qlik.com/t5/QlikView/Need-help-peek-or-previous-function-to-get-last-record-with-val/m-p/1627052#M446180 <P>David, I tried with one field, seems like it is working. I f I have another attribute, it does not work. Do I have to do something differently? For example if I want this logic for NEW_ORGANIZATION and NEW)GROUP as well?</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><STRONG>STATUS</STRONG></TD><TD><STRONG>REFERENCEDATE</STRONG></TD><TD><STRONG>WORKITEMID</STRONG></TD><TD><STRONG>ORGANIZATION</STRONG></TD><TD>NEW_ORGANIATION</TD><TD><STRONG>Group</STRONG></TD><TD><STRONG>New_GROUP</STRONG></TD></TR><TR><TD>Maintenance</TD><TD>1/10/2018</TD><TD>2070400</TD><TD>A1</TD><TD>A1</TD><TD>G1</TD><TD>G1</TD></TR><TR><TD>Maintenance</TD><TD>1/11/2018</TD><TD>2070400</TD><TD>&nbsp;</TD><TD><STRONG>A1</STRONG></TD><TD>&nbsp;</TD><TD>G1</TD></TR><TR><TD>Maintenance</TD><TD>1/12/2018</TD><TD>2070400</TD><TD>&nbsp;</TD><TD><STRONG>A1</STRONG></TD><TD>&nbsp;</TD><TD>G1</TD></TR><TR><TD>Maintenance</TD><TD>1/13/2018</TD><TD>2070400</TD><TD>A2</TD><TD>A2</TD><TD>G2</TD><TD>G2</TD></TR><TR><TD>Maintenance</TD><TD>1/14/2018</TD><TD>2070400</TD><TD>&nbsp;</TD><TD><STRONG>A2</STRONG></TD><TD>&nbsp;</TD><TD>G2</TD></TR><TR><TD>Maintenance</TD><TD>1/15/2018</TD><TD>2070400</TD><TD>&nbsp;</TD><TD><STRONG>A2</STRONG></TD><TD>&nbsp;</TD><TD>G2</TD></TR><TR><TD>Maintenance</TD><TD>1/16/2018</TD><TD>2070400</TD><TD>&nbsp;</TD><TD><STRONG>A2</STRONG></TD><TD>&nbsp;</TD><TD>G2</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD><P>&nbsp;</P><P>&nbsp;</P></TD></TR></TBODY></TABLE> Mon, 23 Sep 2019 16:40:30 GMT https://community.qlik.com/t5/QlikView/Need-help-peek-or-previous-function-to-get-last-record-with-val/m-p/1627052#M446180 gopal5879 2019-09-23T16:40:30Z Re: Need help - peek or previous function to get last record with val for current.info in body https://community.qlik.com/t5/QlikView/Need-help-peek-or-previous-function-to-get-last-record-with-val/m-p/1627270#M446187 <P>The logic stays the same, just change the names of the fields</P> Tue, 24 Sep 2019 07:53:27 GMT https://community.qlik.com/t5/QlikView/Need-help-peek-or-previous-function-to-get-last-record-with-val/m-p/1627270#M446187 DavidM 2019-09-24T07:53:27Z