Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
agni_gold
Valued Contributor 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
Highlighted

Re: Problem in Tree structure

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

Highlighted
agni_gold
Valued Contributor III

Re: Problem in Tree structure

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

Highlighted
agni_gold
Valued Contributor III

Re: Problem in Tree structure

Please help on this , i need some solution

Highlighted

Re: Problem in Tree structure

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

Highlighted
krishna_2644
Valued Contributor III

Re: Problem in Tree structure

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

it should work fine.

PSA for a demo.

Highlighted
agni_gold
Valued Contributor III

Re: Problem in Tree structure

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.

Highlighted
agni_gold
Valued Contributor III

Re: Problem in Tree structure

@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.

Highlighted
MVP & Luminary
MVP & Luminary

Re: Problem in Tree structure

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
Highlighted
MVP & Luminary
MVP & Luminary

Re: Problem in Tree structure

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.