Searching one value of a row on another row

[vesiletaskiran]

Dear Community, 

I have my ticket table as below. Some tickets has reference to other tickets.

How can i return the ticket data only of referenced tickets on straight table?

Thanks in advance. 

Ticket	AdditionalTicket	SomeOtherFields
INM1	E_SRM3	x,y,x
INM2	Y_SRM4	y,y,x,y,x
INM3	INM4	x,y,x
E_SRM2		x,y,x
E_SRM3		u,y,x
E_SRM1		w,y,x
Y_SRM4		t,y,x
INM4		f,y,x

[Vegar · Accepted solution]

I suggest you to look into Hierarchies (Hierarchy/hierarchybelongsto):
https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/DataSource/H...

[vesiletaskiran]

Thank. Correct