Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
New Contributor III

Drill down and hierarchy tree map


I have a  data set which looks like this


L1    L2      L3        L4       L5       Name      LegalID     Finance ID
a america12ab1
ab britain13ab2
abc canada14ab3
abd denmark15ab4
abde egypt16ab5
abdf finland17ab6
ag greece18ab7
ah haiti20cd1
i ireland22cd5
ij jamaica25cd8
ijk kuwait28cd10
ijl london30


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.