How to create hierarchy levels in qlikview

[rish_sai]

Hi,

In my databases I have columns like Org1ID,Org2ID,Org3ID,Org4ID,Org5ID at back end script  I want to combine all columns  make it has hierarchy , can any one help me out to do this Plz.

Thanks in Advance...

[#2]

Hi Rish,

Can you elaborate on what is it exactly you're trying to achieve?

[rish_sai]

I have columns like this

Org1ID,Org2ID,Org3ID,Org4ID,Org5ID instead of creating  hierarchy at frontend , I want to create those Columns come under one hierarchy columns at back end script

[MarcoWedel]

maybe you could create a concatenated field like

LOAD *,
          Org1ID&'/'&Org2ID&'/'&Org3ID&'/'&Org4ID&'/'&Org5ID as OrgID
From YourSource

and use a listbox with the "Show as Tree View" option enabled (using / as separator)

hope this helps

regards

Marco

[QlikToFindOut]

Hi Marco,

I found this method to be incredibly useful and visually, it created what I need but in doing so, I've found that none of the fields are selectable. The entire box is just grey. Any ideas?

My table structure is of a similar build to the original post creator's.

EDIT: The only selectable field is the lowest level.

[MarcoWedel]

Hi,

maybe helpful:

Tree View list box

create a list box as TreeView having only complete dinamic path of a document

regards

Marco

[QlikToFindOut]

Hi,

This unfortunately did not work. In those links, the user assumes that their hierarchy is already somewhat built.

For my case, it's like:

Level5, Level4, Level3, Level2, Level1

If I use your suggestion above, only the lowest level is selectable. Trying to have it such that all levels are selectable.

[MarcoWedel]

please post a sample application to demonstrate

[QlikToFindOut]

Hi,

Re: How to create a listbox hierarchy from a table with many columns?‌

I posted everything in full detail here.