topic Re: My Table has a loop reference in QlikView

My Table has a loop reference

zebhashmi — Wed, 20 Dec 2017 14:56:45 GMT

ID	Father name	Name
1		A
2	1	B

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

Re: My Table has a loop reference

Anil_Babu_Samineni — Wed, 20 Dec 2017 15:16:25 GMT

May be this?

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

Re: My Table has a loop reference

Aurelien_Martinez — Wed, 20 Dec 2017 15:16:31 GMT

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

;

Re: My Table has a loop reference

zebhashmi — Wed, 20 Dec 2017 16:11:35 GMT

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

its not working for me

Re: My Table has a loop reference

zebhashmi — Wed, 20 Dec 2017 16:14:08 GMT

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

Thank you

Re: My Table has a loop reference

Anil_Babu_Samineni — Thu, 21 Dec 2017 01:13:49 GMT

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

Re: My Table has a loop reference

zebhashmi — Thu, 21 Dec 2017 02:14:20 GMT

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

Thank you for pursuing it. let me come back

Re: My Table has a loop reference

zebhashmi — Thu, 21 Dec 2017 02:26:21 GMT

It is working with Qlikview! Thank you!

can you find why it does not work in Qlik sense

Thank you very much

Re: My Table has a loop reference

Anil_Babu_Samineni — Thu, 21 Dec 2017 03:09:48 GMT

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

Re: My Table has a loop reference

zebhashmi — Thu, 21 Dec 2017 13:25:14 GMT

it works in Qlik sense with this

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

Thank you!

Re: My Table has a loop reference

Anil_Babu_Samineni — Thu, 21 Dec 2017 13:28:28 GMT

Great, You want to present full set? The use of 1 is for ignore the all selections only. More info Set identifiers ‒ Qlik Sense

Re: My Table has a loop reference

zebhashmi — Thu, 21 Dec 2017 13:39:30 GMT

yes, I understand its strange with 1 but it is working in qlik sense with this in qlikview it is working without it as it spouse to be.

Re: My Table has a loop reference

Anil_Babu_Samineni — Thu, 21 Dec 2017 13:47:30 GMT

I felt it was wrong, So i thought to test in live. Not sure, What made differ to you

Re: My Table has a loop reference

zebhashmi — Thu, 21 Dec 2017 13:58:54 GMT

Very strange!

I posted my this question in Qliksence Discussion as well I found my answer from there

I don't know how to send a link to that but if you will go there you can find.

my understanding was from there that it should work without 1 but it did not work for me so I put the 1 one and it worked. so it's not only with me.

it was with the person how solved it for me as well. but let me see if I can get the result without it.

Not working for me maybe because I have other tables link to it.

Thank you very much for pursuing!

Re: My Table has a loop reference

Anil_Babu_Samineni — Thu, 21 Dec 2017 14:10:44 GMT

Fine, I just got link My Table has a loop reference

And, From link you haven't provide filter so then it won't to do default it should need {1} in set analysis

Thanks for your patience