topic Re: How to create hierarchy levels in qlikview in QlikView

How to create hierarchy levels in qlikview

rish_sai — Tue, 24 May 2016 19:38:59 GMT

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

Re: How to create hierarchy levels in qlikview

Tue, 24 May 2016 20:08:14 GMT

Hi Rish,

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

Re: How to create hierarchy levels in qlikview

rish_sai — Tue, 24 May 2016 20:17:14 GMT

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

Re: How to create hierarchy levels in qlikview

MarcoWedel — Tue, 24 May 2016 21:53:46 GMT

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

Re: How to create hierarchy levels in qlikview

QlikToFindOut — Tue, 29 May 2018 20:16:40 GMT

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.

Re: How to create hierarchy levels in qlikview

MarcoWedel — Tue, 29 May 2018 21:04:14 GMT

Hi,

maybe helpful:

Tree View list box

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

regards

Marco

Re: How to create hierarchy levels in qlikview

QlikToFindOut — Tue, 29 May 2018 21:13:03 GMT

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.

Re: How to create hierarchy levels in qlikview

MarcoWedel — Tue, 29 May 2018 22:07:45 GMT

please post a sample application to demonstrate

Re: How to create hierarchy levels in qlikview

QlikToFindOut — Wed, 30 May 2018 17:42:41 GMT

Hi,

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

I posted everything in full detail here.