Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

vesiletaskiran
New Contributor III

Searching one value of a row on another row

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. 

TicketAdditionalTicketSomeOtherFields
INM1E_SRM3x,y,x
INM2Y_SRM4y,y,x,y,x
INM3INM4x,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
1 Solution

Accepted Solutions
Partner
Partner

Re: Searching one value of a row on another row

I suggest you to look into Hierarchies (Hierarchy/hierarchybelongsto):
https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/DataSource/H...
???
Celebrating my 300 accepted solution in the Qlik Community
???
2 Replies
Partner
Partner

Re: Searching one value of a row on another row

I suggest you to look into Hierarchies (Hierarchy/hierarchybelongsto):
https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/DataSource/H...
???
Celebrating my 300 accepted solution in the Qlik Community
???
vesiletaskiran
New Contributor III

Re: Searching one value of a row on another row

Thank. Correct