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: 
agni_gold
Specialist III
Specialist III

Problem in Tree structure

Hi All ,

I have one tree structure , but in that the problem was , if i was selecting the parent node then it is not selecting its all the childs , so for removing that issue i have created the trigger for that field,

Trigger Name : Select in Field

And in Field option i have written =if(GetSelectedCount([HFM Entity Tree])>0, 'HFM Entity Tree')

and in string Field i have written

='(' & concat({1<[HFM Entity Tree]={$(=concat(chr(39) & [HFM Entity Tree] & '*' & chr(39), ','))}>}distinct [HFM Entity Tree],'|') & ')'



every thingh is working fine after that , but in one case it is failing


Please see the below screenshot,


xcv.jpg


When i am selecting the TerexUtilities  there are two values are selected. and if i am selecting TerexUtilitiesUSDist then it is working fine .


The problem is only that in my serch string i am making TerexUtilities* so it will serch for both the values .


So please help  me for any workaround.


10 Replies
Nicole-Smith

Why do you  have the '*' in there?  It seems like it's unnecessary.  If you took that part out, it would work.

agni_gold
Specialist III
Specialist III
Author

If we are not using * here then parent Node selection will not work .

agni_gold
Specialist III
Specialist III
Author

Please help on this , i need some solution

Nicole-Smith

Post a sample QVW.  I need the data to mess around with.

krishna_2644
Specialist III
Specialist III

put     ='(' & concat(distinct [HFM Entity Tree],'|') & ')'     in your search string.  

it should work fine.

PSA for a demo.

agni_gold
Specialist III
Specialist III
Author

Hi ,

PFA the sample application what i am using ,

@Nicole Smith

Thanks for your help but my problem is not solved because when i am not able to select the parent node . 

Requirement is that when i select parent node all its child selected.

agni_gold
Specialist III
Specialist III
Author

@Nicole Smith

Thanks for your help but my problem is not solved because when i am not able to select the parent node .

Requirement is that when i select parent node all its child selected.

Gysbert_Wassenaar

Use the HierarchyBelongsTo function instead.

See this blog post: Unbalanced, n-level hierarchies

A user usually wants to make selections referring to the entire sub-tree, but the above solution does not have any field for this. To create such a field, you need the second hierarchy-resolving prefix – the HierarchyBelongsTo

You can find an example in the accompanying document Hierarchies


talk is cheap, supply exceeds demand
jagan
Luminary Alumni
Luminary Alumni

Hi,

Instead of displaying as hierarchy you can go for Multiple listboxes so that there will be more flexibility for users to select.  LIke Group1, SubGroup1, SubGroup2 etc.

Regards,

Jagan.