topic Create Dynamic Listbox based on Hierarchy in QlikView

Create Dynamic Listbox based on Hierarchy

Anonymous — Thu, 08 May 2014 10:16:46 GMT

Hello,

We have certain hierarchy in place. For example Region >> District >> Territory.

What we planning here is, dynamic listbox should be created based on hierarchical levels, i.e. for separate listboxes for each Region District & Territory.

Levels can increased to 10th level.

Is there any way or approach to create dynamic listboxes.

Please Help

Re: Create Dynamic Listbox based on Hierarchy

MarcoWedel — Thu, 08 May 2014 11:11:46 GMT

you could use the build in TreeView option of list boxes (properties/general tab)

Just create a field that contains the complete hierarchy e.g. like Region/District/Territory or use an expression in the listbox like =Region&'/'&District&'/'&Territory.

The defined seperator has to match the seperator used to create the field values (here: '/')

hope this helps

regards

Marco

Re: Create Dynamic Listbox based on Hierarchy

tresB — Thu, 08 May 2014 11:15:19 GMT

Have a look at hierarchy prefix, it would create multiple Nodes dynamically.

Re: Create Dynamic Listbox based on Hierarchy

Anonymous — Thu, 08 May 2014 11:26:38 GMT

Thanks for reply guys. I am able to achieve this.

What i want here is creating dynamic listbox.

If in hierarchy there are 3 levels then 3 Listbox should be display and so on....

Re: Re: Create Dynamic Listbox based on Hierarchy

MarcoWedel — Thu, 08 May 2014 21:39:19 GMT

maybe this could be the solution?

=SubField(Hierarchy, '/',3)

=max(SubStringCount(Hierarchy,'/'))+1>=3

hope this helps

regards

Marco