topic Re: Tree View Hierarchy Associativity in QlikView

Tree View Hierarchy Associativity

Mon, 24 Feb 2014 17:05:13 GMT

HI all,

I have built hierarchies in tree view format but don't know how to show the associativity (highlight the related field ).

attached is pic where i have data FMS CONN->Total Channel> Week 1 but all weeks have data but it doesn't highlight all weeks associated with FMS->Total Channel.

Please share your exp.

Re: Tree View Hierarchy Associativity

hic — Mon, 24 Feb 2014 18:49:22 GMT

If you want to be able to make selections in any level in the tree-view list box, you need to have one record per node in the data model. See http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/11/unbalanced-n-level-hierarchies

The bottom line is that unless you have the data loaded as an unbalanced n-level hierarchy, the tree-view list box is not suitable.

HIC

Re: Tree View Hierarchy Associativity

Tue, 25 Feb 2014 05:56:55 GMT

Yes... i have one record for each node in data model but problem comes

Parent Group Channel Week1

Parent Tot Chnl 100

Child1 Tot Chnl 30

Child2 Tot Chnl 70

Now in list box if i select Child1 -> Total Chl-> Week 1 i get 30 and same for child 2 i get 70 which is right but when i select Parent -> Tot Chnl -> week 1 i get 200 (I sud get only 100). this is happening coz parent has 100 + child 1 has 30 + child 2 has 70 = 200.

How to remove addition or just show Parent data only fetching from data model ?????

Re: Tree View Hierarchy Associativity

amit_saini — Tue, 25 Feb 2014 06:03:08 GMT

Hi Vishal,

Hope this will help you, please find the attachment.

Thanks,

Re: Tree View Hierarchy Associativity

er_mohit — Tue, 25 Feb 2014 06:23:44 GMT

see the attached file

Re: Tree View Hierarchy Associativity

Tue, 25 Feb 2014 06:32:12 GMT

hi vishal,

i have this example For hierarchy

from this example u can easily understand how to create hierarchy in qlikview

Re: Tree View Hierarchy Associativity

Tue, 25 Feb 2014 06:42:10 GMT

anyone can help me with issue.

Fact Table (Data Model)

Parent Group Channel Week1

Parent Tot Chnl 100

Child1 Tot Chnl 30

Child2 Tot Chnl 70