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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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.