Create listbox treeview

[#1]

Hi I need help creating a listbox tree view in my dashboard. This is the order I want from top to bottom: LOB, SUB LOB, SUB LOB2, & SUB LOB3. When clicking on a LOB, SUB LOB should expand. When clicking on SUB LOB, SUB LOB2 should expand. and so on. How can I get this to work?

[#2]

Sorry I cannot because it is confidential information.

The fields are filled with string values. In Lob there are 5 data rows along with one that is named 'Unknown'. Also there is one row on the top that has nothing. It is an empty row with the same depth. The first three levels are grayed out but the fourth one is not grayed out. Each of them has a plus box to the left of them. When I click on the plus box, it expands to Sub Lob, but that is also grayed out.

[chrismarlow]

So If Lob has value 1 say you want 'Sub Lob' to show where Lob=1, but otherwise be hidden? This sounds a bit like the behaviour of the drill down on a pivot table, rather than using a list box ...

... right lines?

[swuehl]

You don't have to post your real, confidential data, but you should be able to post a table with mock up sample records that come close to your real setting.

[#5]

I appreciate the help. It turns out that I need to use a pivot table instead of a tree view list box. I was informed that a tree view list box only shows the underlying data, which is the lowest level of a tree view list box. That is why I can only select the lowest level.

Now my only problem with the pivot table is that I want it to collapse when I click clear and I want the second column to expand when I click on any information from the first column.

[#6]

You're right. I need to use a pivot table for this, which I have.

Now my problems with the pivot table is that I want it to collapse when I click clear and I want the second column to expand when I click on any information from the first column.

[swuehl]

I was informed that a tree view list box only shows the underlying data, which is the lowest level of a tree view list box. That is why I can only select the lowest level.

I don't think so.

[anagharao]

Hi,

The lowest level of the tree is what links to your fact table hence they can be selected and the top levels are grayed out. You would have to create an association with the lowest level of the tree and all its parents/ancestors. To do this you would have to use "HierarchyBelongsTo" function available in qlik.

I've attached a QVW explaining the process. Hope that helps.