Drill down and hierarchy tree map

Anonymous — Mon, 08 May 2017 15:37:44 GMT

Hi,

I have a data set which looks like this

L1	L2	L3	L4	L5	Name	LegalID	Finance ID
a					america	12	ab1
a	b				britain	13	ab2
a	b	c			canada	14	ab3
a	b	d			denmark	15	ab4
a	b	d	e		egypt	16	ab5
a	b	d	f		finland	17	ab6
a	g				greece	18	ab7
a	h				haiti	20	cd1
i					ireland	22	cd5
i	j				jamaica	25	cd8
i	j	k			kuwait	28	cd10
i	j	l			london	30	cd13

Now i have created a drill down dimension with L1,L2, L3, L4 , L5. and i am showing that in a pivot table.

i want to create a tree map too such that when i search for a legal id, the corresponding tree map should highlight the node (its predecessor and children).

Any help is much appreciated.

Thanks!!

topic Drill down and hierarchy tree map in QlikView

Drill down and hierarchy tree map