topic Re: List table Tree Hierarchy in QlikView

List table Tree Hierarchy

Sean_BI — Sat, 16 Nov 2024 19:59:17 GMT

Hello QV Experts -

I need to build treeview structure for list box.

when Region is selected all the members under Region should be auto selected.

when State is selected all the members under State should be auto checked.

when City is selected all the members under City should be auto checked.

Issue:

The State check box selection is disabled. I need the ability select Region, State and City check boxs.

Script:

BuildHier:
LOAD Region,
State,
City,
Region &'/'& State &'/'& City as Hier1
FROM
[C:\User\Qlikview Samples\Hierarchy_Example.xlsx]
(ooxml, embedded labels, table is Sheet3);

Concatenate(BuildHier)
Load Distinct
Region,
Region as Hier1
Resident BuildHier;

Concatenate(BuildHier)
Load Distinct
Region,
State,
Region as Hier1
Resident BuildHier;

Concatenate(BuildHier)
Load Distinct
Region,
State,
City,
Region as Hier1
Resident BuildHier;

Appreciate any assistance here.

Rgds,

Sean.

Re: List table Tree Hierarchy

sergio0592 — Sun, 29 Sep 2019 19:04:57 GMT

Hi,

Have you checked "Show as tree view"in Properties/General tabs ?

Re: List table Tree Hierarchy

Sean_BI — Sun, 29 Sep 2019 19:07:27 GMT

Yes. Show as treeview is enabled and / as delimeter.

Can I use hierarchybelongs to function to build nodes. But I don't have node id, and parent I'd to build hierarchy using hierarchy method.

Rgds, Sean.

Re: List table Tree Hierarchy

sergio0592 — Sun, 29 Sep 2019 19:18:37 GMT

I have on case where i use Tree Hierarchy in list box. But the field used results of Oracle hierarchical function (SYS_CONNECT_BY_PATH).