topic Re: Create listbox treeview in QlikView

Create listbox treeview

Wed, 27 Jul 2016 19:08:50 GMT

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?

Re: Create listbox treeview

maheshkuttappa — Wed, 27 Jul 2016 19:32:33 GMT

Can you provide some sample data

Re: Create listbox treeview

Wed, 27 Jul 2016 19:50:35 GMT

Sorry I cannot because it is confidential information.

Re: Create listbox treeview

Wed, 27 Jul 2016 20:12:45 GMT

This?

Re: Create listbox treeview

swuehl — Wed, 27 Jul 2016 20:26:54 GMT

You can create the TreeView like this:

LOAD * INLINE [

Item, TreeView

LOB, LOB

SUB LOB,LOB/SUB LOB

SUB LOB2, LOB/SUB LOB/SUB LOB2

SUB LOB3, LOB/SUB LOB/SUB LOB2/SUB LOB3

];

Re: Create listbox treeview

Thu, 28 Jul 2016 12:50:23 GMT

Sorry I should have specified. Lob, Sub Lob, Sub Lob2, & Sub Lob3 are the column names from a excel spreadsheet. Each columns has information in them. That is the right format but the data from each column is not listed under each column name when expanded.

Re: Create listbox treeview

Thu, 28 Jul 2016 12:50:35 GMT

Re: Create listbox treeview

swuehl — Thu, 28 Jul 2016 15:15:36 GMT

If I understand correctly, create a new field in your load script, that concatenates your fields with a delimiter, e.g. '/'.

LOAD

Lob,

"Sub Lob",

"Sub Lob 2",

"Sub Lob 3",

Lob &'/'& "Sub Lob" &'/'& "Sub Lob 2" &'/'& "Sub Lob 3" as TreeView,

...

FROM ...;

Re: Create listbox treeview

Thu, 28 Jul 2016 15:43:07 GMT

Everything is grayed out except for the data in Sub Lob3 which is the deepest level. I am only able to select data in that field and nothing else. The data in Lob, Sub Lob, and Sub Lob2 is grayed out. Also each depth header is gone such as Lob, Sub Lob, etc.

How can I get the list box to look like the first tree view list you showed me with the data in each column?

How can I get rid of the grayed out fields? I made sure I am not selecting anything in the dashboard.

Re: Create listbox treeview

swuehl — Thu, 28 Jul 2016 16:02:22 GMT

Are the fields are only partially filled with values and show mostly NULL in e.g. Lob field?

Could you post a sample input file?

Re: Create listbox treeview

Thu, 28 Jul 2016 16:13:01 GMT

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.

Re: Create listbox treeview

chrismarlow — Thu, 28 Jul 2016 16:31:41 GMT

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?

Re: Create listbox treeview

swuehl — Thu, 28 Jul 2016 17:26:30 GMT

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.

Re: Create listbox treeview

Thu, 28 Jul 2016 18:37:40 GMT

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.

Re: Create listbox treeview

Thu, 28 Jul 2016 18:45:29 GMT

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.

Re: Create listbox treeview

swuehl — Thu, 28 Jul 2016 19:26:21 GMT

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.

Re: Create listbox treeview

anagharao — Fri, 29 Jul 2016 04:05:35 GMT

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.