topic Re: List Box hierarchy? in QlikView

List Box hierarchy?

Thu, 02 Jul 2015 04:03:02 GMT

Hi All,

I need Urgent requirement,

a list box Hierarchy with example.

Live req:

I have Bank ID and In that bank id have n number of node Like Bank ID-> Branch-> Department -> Sub Dep-> Revenue

I need to show this on List box. When i choose list box selection need to display pivot or table box.

Kindly Help me.

Data:

Group

Name A

Name B

Name C

Name D

Name E

Name F

Name G

Length

Best Name

Path

OID

Parent Name

Admin

234

Memo

Admin>A>B>CD>E>Memo

123

Best

User

ABC

212

Gemo

User>ABC>DE>MN>Z>N>Gemo

443

Gest

Admin1

431

Lemo

Admin>Q>W>E>R>V>Lemo

554

Lest

Ramya.

Re: List Box hierarchy?

Thu, 02 Jul 2015 04:15:24 GMT

Can you provide sample data for the requirement? Do you have the data in the format of Adjacent nodes table? If yes, that can be converted to Expanded nodes table using Hierarcy keyword. There you need to specify the delimiter/Separator for different nodes. Use that in the list box properties -> Show as Tree View -> With Separator.

I didn't understand 'When i choose list box selection need to display pivot or table box.' Elaborate your requirement.

Regards,

KKR

Re: List Box hierarchy?

Thu, 02 Jul 2015 04:20:52 GMT

Hi,

Could you please elaborate your requirement.

Provide some sample data and the required output screen shot.

Regards,

Jemimah

Re: List Box hierarchy?

Anonymous — Thu, 02 Jul 2015 04:33:45 GMT

Hi Ramya,

Please go through this link:

https://community.qlik.com/docs/DOC-5490#comment-34684

Hope it will helpful!!

Re: List Box hierarchy?

Thu, 02 Jul 2015 04:41:33 GMT

Data:

Group

Name A

Name B

Name C

Name D

Name E

Name F

Name G

Length

Best Name

Path

OID

Parent Name

Admin

234

Memo

Admin>A>B>CD>E>Memo

123

Best

User

ABC

212

Gemo

User>ABC>DE>MN>Z>N>Gemo

443

Gest

Admin1

431

Lemo

Admin>Q>W>E>R>V>Lemo

554

Lest

Ramya.

Re: List Box hierarchy?

Thu, 02 Jul 2015 04:45:29 GMT

Mail id Please. I can send u data

Re: List Box hierarchy?

Thu, 02 Jul 2015 04:45:36 GMT

Mail id Please. I can send u data

Re: List Box hierarchy?

hariprasadqv — Thu, 02 Jul 2015 04:53:04 GMT

Hi,

Prepare a table with the fields PARENTID,CHILDID and NODENAME then you can use hierarchy() function to create hierarchy in the script itself.

Thanks

Re: List Box hierarchy?

timanshu — Thu, 02 Jul 2015 06:49:58 GMT

Hi,

Using Hierarchy function will solve purpose. Attach data to let me do

Re: List Box hierarchy?

sunilkumarqv — Thu, 02 Jul 2015 07:07:09 GMT

This helps you to load list box hierarchy

Hierarchy function easy and Efficient with example---

Re: List Box hierarchy?

vardhancse — Thu, 02 Jul 2015 07:20:31 GMT

Hi,

I think your requirement is to show in hierarchy structure, is that correct.?

if so we can do using delimiter something like'\'

Table:

LOAD * INLINE [

%Dim, %Dim_Subgroup

01, Main

02, Main\Branch

03, Main\Group

];

in the list box:

Properties->General->Show as tree view->With separator \

So that in list box you can see Main, on expand you can see branch and group

Re: List Box hierarchy?

jagan — Thu, 02 Jul 2015 07:37:19 GMT

Hi,

You can try like this

List Box Properties->General->Show as tree view->and give >

and also select ID as Field

Regards,

jagan.