topic Re: Problem in Tree structure in QlikView

Problem in Tree structure

agni_gold — Wed, 15 Jul 2015 13:05:14 GMT

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,

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.

Re: Problem in Tree structure

Nicole-Smith — Wed, 15 Jul 2015 16:45:52 GMT

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

Re: Problem in Tree structure

agni_gold — Thu, 16 Jul 2015 10:16:42 GMT

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

Re: Problem in Tree structure

agni_gold — Thu, 16 Jul 2015 18:46:37 GMT

Please help on this , i need some solution

Re: Problem in Tree structure

Nicole-Smith — Thu, 16 Jul 2015 19:21:44 GMT

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

Re: Problem in Tree structure

Qrishna — Thu, 16 Jul 2015 19:47:49 GMT

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

it should work fine.

PSA for a demo.

Re: Problem in Tree structure

agni_gold — Thu, 16 Jul 2015 20:04:11 GMT

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.

Re: Problem in Tree structure

agni_gold — Thu, 16 Jul 2015 20:04:39 GMT

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

Re: Problem in Tree structure

Gysbert_Wassenaar — Fri, 17 Jul 2015 04:47:52 GMT

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

Re: Problem in Tree structure

jagan — Sat, 18 Jul 2015 00:38:43 GMT

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.

Re: Problem in Tree structure

Nicole-Smith — Sun, 19 Jul 2015 01:04:17 GMT

I changed the load script (to get the Depth field necessary for the trigger) and the trigger for the OnSelect action. I've attached my copy of the QVW. This works as you're expecting. !