topic Return subsequent values of a field in App Development

topic Return subsequent values of a field in App Development https://community.qlik.com/t5/App-Development/Return-subsequent-values-of-a-field/m-p/2041070#M85753 <P>Hi</P> <P>I want to obtain field2 based on the the subsequent values of a field 1  using as reference field1 value from where Flag exists (example table below)</P> <P>I tried  Field2=Wildmatch (Field1,Field1&'*')  but did not work.  Any thoughts?</P> <P>Thank you</P> <TABLE width="252"> <TBODY> <TR> <TD width="98">Field 1 </TD> <TD width="64">Flag</TD> <TD width="90">Field2</TD> </TR> <TR> <TD>1!</TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>1!2!</TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>1!2!3!</TD> <TD>X</TD> <TD>1!2!3!</TD> </TR> <TR> <TD>1!2!3!4!</TD> <TD> </TD> <TD>1!2!3!4!</TD> </TR> <TR> <TD>1!2!3!4!5!</TD> <TD> </TD> <TD>1!2!3!4!5!</TD> </TR> <TR> <TD>2!</TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>2!3!</TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>2!3!4!</TD> <TD>X</TD> <TD>2!3!4!</TD> </TR> <TR> <TD>2!3!4!5!</TD> <TD> </TD> <TD>2!3!4!5!</TD> </TR> </TBODY> </TABLE> <P> </P> Wed, 22 Feb 2023 17:20:00 GMT Pestaninha 2023-02-22T17:20:00Z Return subsequent values of a field https://community.qlik.com/t5/App-Development/Return-subsequent-values-of-a-field/m-p/2041070#M85753 <P>Hi</P> <P>I want to obtain field2 based on the the subsequent values of a field 1  using as reference field1 value from where Flag exists (example table below)</P> <P>I tried  Field2=Wildmatch (Field1,Field1&'*')  but did not work.  Any thoughts?</P> <P>Thank you</P> <TABLE width="252"> <TBODY> <TR> <TD width="98">Field 1 </TD> <TD width="64">Flag</TD> <TD width="90">Field2</TD> </TR> <TR> <TD>1!</TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>1!2!</TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>1!2!3!</TD> <TD>X</TD> <TD>1!2!3!</TD> </TR> <TR> <TD>1!2!3!4!</TD> <TD> </TD> <TD>1!2!3!4!</TD> </TR> <TR> <TD>1!2!3!4!5!</TD> <TD> </TD> <TD>1!2!3!4!5!</TD> </TR> <TR> <TD>2!</TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>2!3!</TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>2!3!4!</TD> <TD>X</TD> <TD>2!3!4!</TD> </TR> <TR> <TD>2!3!4!5!</TD> <TD> </TD> <TD>2!3!4!5!</TD> </TR> </TBODY> </TABLE> <P> </P> Wed, 22 Feb 2023 17:20:00 GMT https://community.qlik.com/t5/App-Development/Return-subsequent-values-of-a-field/m-p/2041070#M85753 Pestaninha 2023-02-22T17:20:00Z