My Table has a loop reference

[zebhashmi]

ID	Father name	Name
1		A
2	1	B

By selecting 2 want to display its Father Name which is A in this Example.

[Anil_Babu_Samineni · Accepted solution]

May be this?

=Only({<ID = P([Father name]) >} Name)

[Aurelien_Martinez]

Hi,

data:

Load * Inline [

ID, Father name, Name

1, , A

2, 1, B

];

left join (data)

Load

ID as [Father name],

Name as [Name Father name]

restident data

;

[zebhashmi]

=Only({<UPID = P(Father_UPID)>}[First Name])

its not working for me

[zebhashmi]

I can't do that on script side looking in expression side

Thank you

[Anil_Babu_Samineni]

Where are you trying this? I am getting as expected in text box

[zebhashmi]

Ok, let me try with Qlikview text object. I tried it with Qlik sense KPI

Thank you for pursuing it. let me come back

[zebhashmi]

It is working with Qlikview! Thank you!

can you find why it does not work in Qlik sense

Thank you very much

[Anil_Babu_Samineni]

I believe QIX is same for view and sense, It should work? Can you show image in QS

[zebhashmi]

it works in Qlik sense with this

=Only({1<UPID=p(Father_UPID)>}[First Name])

Thank you!