https://community.qlik.com/t5/App-Development/Most-Recent-Value-in-Parent-Child-Hierarchy/m-p/1674565#M51186 <P>I have airline ticket data that contains exchanges.&nbsp; The exchanges reference the preceding ticket in the Originating Ticket column.&nbsp; In this example, Tix1 is the original first ticket, Tix2-5 are exchanges, and Tix5 is the most recent or current ticket.&nbsp; The requirement is to aggregate the $ for these up to the most recent ticket #, Tix5.&nbsp; Any wisdom on how to accomplish this?&nbsp; THANKS!</P><TABLE width="273"><TBODY><TR><TD width="42">Ticket</TD><TD width="109">Originating Ticket</TD><TD width="122"><FONT color="#0000FF"><EM>Most Recent Ticket</EM></FONT></TD></TR><TR><TD>Tix1</TD><TD>&nbsp;</TD><TD><FONT color="#0000FF"><EM>Tix5</EM></FONT></TD></TR><TR><TD>Tix2</TD><TD>Tix1</TD><TD><FONT color="#0000FF"><EM>Tix5</EM></FONT></TD></TR><TR><TD>Tix3</TD><TD>Tix2</TD><TD><FONT color="#0000FF"><EM>Tix5</EM></FONT></TD></TR><TR><TD>Tix4</TD><TD>Tix3</TD><TD><FONT color="#0000FF"><EM>Tix5</EM></FONT></TD></TR><TR><TD>Tix5</TD><TD>Tix4</TD><TD><FONT color="#0000FF"><EM>Tix5</EM></FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P> Sat, 16 Nov 2024 03:17:57 GMT jdean1012 2024-11-16T03:17:57Z https://community.qlik.com/t5/App-Development/Most-Recent-Value-in-Parent-Child-Hierarchy/m-p/1674565#M51186 <P>I have airline ticket data that contains exchanges.&nbsp; The exchanges reference the preceding ticket in the Originating Ticket column.&nbsp; In this example, Tix1 is the original first ticket, Tix2-5 are exchanges, and Tix5 is the most recent or current ticket.&nbsp; The requirement is to aggregate the $ for these up to the most recent ticket #, Tix5.&nbsp; Any wisdom on how to accomplish this?&nbsp; THANKS!</P><TABLE width="273"><TBODY><TR><TD width="42">Ticket</TD><TD width="109">Originating Ticket</TD><TD width="122"><FONT color="#0000FF"><EM>Most Recent Ticket</EM></FONT></TD></TR><TR><TD>Tix1</TD><TD>&nbsp;</TD><TD><FONT color="#0000FF"><EM>Tix5</EM></FONT></TD></TR><TR><TD>Tix2</TD><TD>Tix1</TD><TD><FONT color="#0000FF"><EM>Tix5</EM></FONT></TD></TR><TR><TD>Tix3</TD><TD>Tix2</TD><TD><FONT color="#0000FF"><EM>Tix5</EM></FONT></TD></TR><TR><TD>Tix4</TD><TD>Tix3</TD><TD><FONT color="#0000FF"><EM>Tix5</EM></FONT></TD></TR><TR><TD>Tix5</TD><TD>Tix4</TD><TD><FONT color="#0000FF"><EM>Tix5</EM></FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P> Sat, 16 Nov 2024 03:17:57 GMT https://community.qlik.com/t5/App-Development/Most-Recent-Value-in-Parent-Child-Hierarchy/m-p/1674565#M51186 jdean1012 2024-11-16T03:17:57Z