Need help

[soniasweety]

Hi all,OmarBenSalem

  @Michael_Tarallo

Gysbert_Wassenaar

Kaushik_solanki

i have a hierarchy  visualisation in qliskense   i have downloaded the extension  family .  so i am facing one issue  

when i select  parent from   family identifier  that related childs is coming  but  from that if i select that  should be as parent   

but here  its not taking       

Selection criteria to see the issue:     163267-Tab  from  Family identifier   THEN SELECT  -Ric tab-107328   --

the result should be  Ric tab as parent but its coming    Dan Tab

what might be the issue can anyone help?   extension and app is attached

thanks

[soniasweety]

yes am using that only. and if i select any child name that become as parent like that

[pradosh_thakur]

Do you mean , you want the parent to be hidden when clicked on it's child and the child to become parent i.e. chart should start from the child and it's sub child?

[soniasweety]

yeah exactly.

[sunny_talwar]

I have not used the extension before and I am not 100% sure how it works, but I get what you are trying to say. If you select Ric Tab 107328, you would like to see Cha 638223, Dan Tab-106017, Har Tab 102024, and Les Tab 209442 because Ric Tab is the parent to these 4, right?

Unfortunately, I have no idea how to do it. 

[soniasweety]

Hi sunny,

1st   screen shot   family identifier  -163267-Tab select    it will display  that is correct

2nd screen shot-   i selected Ric Tab-107328       that should became as parent   instead   Dan-Tab is coming.

[soniasweety]

1st 

[soniasweety]

Hi

if i use below script its working  as expected but..   in front end  values coming with (1),(2)  like that   user dont want that.

Pradosh_thakur
TreeData:
LOAD
ParentRecordMasterID,
ChildRecordMasterID,
Child_Name,

(If(FamilyRelationshipLevel,Child_Name&'('&FamilyRelationshipLevel&')',Child_Name)) as Child_Name1,
FamilyIdentifier,
FamilyRelationshipLevel,
Relationship,
Rating,
Donations
FROM [lib://FamilyData/TreeData.xlsx]
(ooxml, embedded labels, table is Sheet1);

Dan-Tab-106017(1)      with in bracket (1),(2)  is coming  ....  i need with out that.