Chart - Filtering a hierarchy

simonb2013 — Thu, 11 May 2017 10:37:50 GMT

Short version is :

when a user clicks on Dimension2 of my chart, I want the selected value to be applied to Dimension1 instead of Dimension2.

Longer version with background is ......

As per the title, I am working with a Hierarchy.

I have my source 'Adjacent' table. (Node-Parent)

I used 'Hierarchy' to generate a 'PATH' table.

Also used 'HierarchyBelongsTo' to create a 'Branch' table.

For the UI, I am using a Gant Chart. (Grouped bar chart with Bar Offsets)

Dimension 1 = 'BranchID'

Dimension 2 = 'NodeID' (sorted by time)

Expression = max([Node_EndTime]) - max([Node_StartTime])

Offset = min([Node_StartTime])

Works lovely, and visualises the time structure of my hierarchy tree wonderfully.

However, when it comes to filtering the chart tree, I have limited behaviour.

If use selects a node (bar) in the chart, it filters by NodeID.

What I would like, in a perfect world, if that the selected node becomes the new root for the displayed tree.

So, in effect, when a user clicks in a NodeID, I actually want to filter the chart :

where [BranchID] = Clicked [NodeID]

Is this possible ?!?!

Thanks in advance

topic Chart - Filtering a hierarchy in QlikView