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?

[maheshkuttappa]

Can you provide some sample data

[#3]

Sorry I cannot because it is confidential information.

[#4]

This?

[swuehl]

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

];

[#6]

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.

[#7]

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.

[swuehl]

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 ...;

[#9]

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. 

[swuehl]

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?