topic TreeView In ListBox in QlikView

TreeView In ListBox

jagannalla — Wed, 25 May 2011 13:28:07 GMT

Hi,

- Can anybody give me example on listbox to display in treeview format.

- I've seen option "Show as treeview" in General Tab of ListBox properties.

What is the use of it?

TreeView In ListBox

nagaiank — Wed, 25 May 2011 13:58:06 GMT

In order to show a field as treeview, the field should contain hierarchical data. The section on 'Hierarchies' in the QlikView Reference Manaul has more information.

TreeView In ListBox

Wed, 25 May 2011 14:01:00 GMT

Hi Jagan ,

If you have any recursive data / hierarical data and you want to display the relation in between parent and child in a tree view you can show that in listbox let us assume I have my data like this

Parent. Child. Level

A. B 1.0.0

A C. 2.0.0

B. D. 1.1.0

B. E. 1.2.0

C. F. 2.1.0

F. G. 2.1.1

Now the data is in a hierarchy data and if u want to see which level go to which node

Then u can go to a list box and u can display the whole data in a tree view like

You can see your data in a sort of way like this may be I failed to give you a perfect view but this is the use of tree view in a list box

I'll try to post you a qwv file with treeview but gimme some time

Thankyou

Brad

TreeView In ListBox

jagannalla — Thu, 26 May 2011 10:57:51 GMT

Ok Bradd I'll wait for your solution. But i'm using personal edition can you plz say the procedure.

TreeView In ListBox

Thu, 26 May 2011 12:56:26 GMT

Hi Jagan ,

Can you try to create a data which is recursive and hierarical in a excel sheet

So that we can make the hierarical relation between the data fields using hierarchy function which helps us th create our own hierarchy's u can go thru the help for the syntax of hierarchy function

Once you are done with creating hierarchy's you can use the tree view option of listbox's in your personal edition of Qlikview also .

Thanks a lot

Bradd

TreeView In ListBox

Thu, 26 May 2011 13:25:41 GMT

Hi Jaganalla,

if you want to create a TreeView without using excel, you can create your TreeView beginning in the script:

(TMAT_PMATNR&'-/-'&TMAT_BMATN&'-/-'&TMAT_LAST_CHILD) as [Superior and related Materials]

As you can see i use -/- as the separator.

The TreeView has 3 levels

TMAT_PMATNR is the first level TMAT_BMATN is the second level and TMAT_LAST_CHILD is the third level.

After creating the field for the TreeView i created a listbox selected the filed Superior and related Materials chose TreeView and entered the separator -/- like i unsed it. You can format the separator as you want - you shall just use the same in the listbox and in the script.

eg: NAME1&'---'&NAME2 as TREEVIEW

then you have to select TREEVIEW and you will get a result like

NAME1

second level NAME2

Hope this helps a little bit

Christoph

Re: TreeView In ListBox

Anonymous — Mon, 04 Feb 2013 15:25:23 GMT

Hi Jagan,

Pls find solution in below link. Hope this helps you.

http://community.qlik.com/qlikviews/1072

Rgds,

Nandha