List Box hierarchy?

[#1]

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

ID

Best Name

Path

OID

Parent Name

Admin

A

B

C

CD

E

1

234

Memo

Admin>A>B>CD>E>Memo

123

Best

User

ABC

DE

MN

Z

N

2

212

Gemo

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

443

Gest

Admin1

Q

W

E

R

V

22

431

Lemo

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

554

Lest

Ramya.

[#2]

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

[#3]

Hi,

Could you please elaborate your requirement.

Provide some sample data and the required output screen shot.

Regards,

Jemimah

[Anonymous]

Hi Ramya,

Please go through this link:

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

Hope it will helpful!!

[#5]

Data:

Group

Name A

Name B

Name C

Name D

Name E

Name F

Name G

Length

ID

Best Name

Path

OID

Parent Name

Admin

A

B

C

CD

E

1

234

Memo

Admin>A>B>CD>E>Memo

123

Best

User

ABC

DE

MN

Z

N

2

212

Gemo

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

443

Gest

Admin1

Q

W

E

R

V

22

431

Lemo

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

554

Lest

Ramya.

[#6]

Mail id Please. I can send u data

[#7]

Mail id Please. I can send u data

[hariprasadqv]

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

[timanshu]

Hi,

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

[sunilkumarqv]

This helps you to load list box hierarchy 

Hierarchy function easy and Efficient with example---