Quick question regarding a chart I am trying to create. I have a hierarchical vendor table in my database that is self referencing (vendor id, vendor name, vendor parent id). I loaded the table and then used the Hierarchy Function to explode the levels into columns within my Qlikview table. To keep it simple, I am using a balanced 2 level hierarchy (in reality it's unbalanced and unknown depth, I'll deal with this later 🙂 .
I want to enable the user to be able to select a node at any depth in the hierarchy and have that node plotted on a line chart. For example, if the user selects a parent vendor, the total purchases for that vendor would be plotted. The user may also select the parent and it's children (all or some of them) to be plotted on the same chart.
How is this typically accomplished?
I'm still very new to Qlikview and like what I see so far. Any help is appreciated.
So I've implemented Hierarchy() and HierarchyBelongsTo() to assist with my dashboard.
I created a list box and used the "Path" column in the expanded nodes table as the dimension. Then, I selected the check box to display it as a TreeView. This works great as I can easily traverse my hierarchy. However, I still have a few outstanding issues:
1) When I expand a node the list box, it "refreshes" and displays the top of the list. This is problematic because it's really hard to see what you selected (e.g. If I expand a node in the middle of the list, the user has to scroll back down the list to see the children of that node). Is there any property that controls this?
2) If I only want to select the parent node, but not the children what dimension should I use on my chart? Currently, I can select the parent only, but nothing is shown on the chart (because the parent isn't linked to any transactions). If on the otherhand, I select the parent and all of it's chidren, the parent and it's children are plotted on the chart. This is problematic for parents with many children, since there will be too many lines on my graph. Similarly, if not all of the children are plotted, the aggregated numbers for the parent only include the children that are selected.
