Regarding TreeView in ListBox

Mon, 23 Jun 2014 01:34:38 GMT

Hello Guys,

Kindly help me with my problem in hierarchical data.

Actually I got a table with ParentEntityID and EntityID hierarchy. I have already created the hierarchy in the script but I was not able to show the hierarchy in the listbox.

Script for reference:

Hierarchy(EmployeeBusinessEntityID, ParentEmployeeBusinessEntityID, FirstName,ResourcePath,'|',PathDepth)

SQL SELECT BaseRate,

BirthDate,

CurrentFlag,

DepartmentName,

EmailAddress,

EmergencyContactName,

EmergencyContactPhone,

EmployeeBusinessEntityID,

EndDate as Employee_EndDate,

FirstName,

Gender,

HireDate,

LastName,

MaritalStatus,

MiddleName,

ParentEmployeeBusinessEntityID,

PayFrequency,

Phone,

SalariedFlag,

SalesPersonFlag,

SalesTerritoryKey,

SickLeaveHours,

StartDate as Employee_StartDate,

Status,

Title,

VacationHours

FROM Employee;

After reload,I created a listbox for ResourcePath field with tree view check box enabled but still, I am not getting the tree view in the list box.

Kindly let me know if you know any possible solutions

Thanks

Kiru

Re: Regarding TreeView in ListBox

Mon, 23 Jun 2014 02:56:32 GMT

PFA. You need to adjust the script according to your columns.

Re: Regarding TreeView in ListBox

Mon, 23 Jun 2014 02:58:57 GMT

Re: Regarding TreeView in ListBox

tresB — Mon, 23 Jun 2014 04:57:55 GMT

The default separator in listbox for treeview is '/', have you changed it to '|' ?

Re: Regarding TreeView in ListBox

Mon, 23 Jun 2014 13:21:32 GMT

Thank you so much for all your helpful answers guys and I really appreciate your time!

Best,

Kiru

topic Regarding TreeView in ListBox in QlikView

Regarding TreeView in ListBox

Re: Regarding TreeView in ListBox

Re: Regarding TreeView in ListBox

Re: Regarding TreeView in ListBox

Re: Regarding TreeView in ListBox