Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

List Box hierarchy?

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:

           

GroupName AName BName CName DName EName FName GLengthIDBest NamePathOIDParent Name
AdminABCCDE1234MemoAdmin>A>B>CD>E>Memo123Best
UserABCDEMNZN2212GemoUser>ABC>DE>MN>Z>N>Gemo443Gest
Admin1QWERV22431LemoAdmin>Q>W>E>R>V>Lemo554Lest

Ramya.

11 Replies
vardhancse
Specialist III
Specialist III

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

jagan
Partner - Champion III
Partner - Champion III

Hi,

You can try like this

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


and also select ID as Field


Regards,

jagan.