Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zebhashmi
Specialist
Specialist

My Table has a loop reference

IDFather nameName
1A
21B

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

1 Solution

Accepted Solutions
Anil_Babu_Samineni

May be this?

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

14 Replies
Anil_Babu_Samineni

May be this?

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

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

;

Help users find answers! Don't forget to mark a solution that worked for you!
zebhashmi
Specialist
Specialist
Author

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

its not working for me

zebhashmi
Specialist
Specialist
Author

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
zebhashmi
Specialist
Specialist
Author

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
Specialist
Specialist
Author

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
zebhashmi
Specialist
Specialist
Author

it works in Qlik sense with this

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

Thank you!