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.
