Tree List box issue

[shyamcharan]

Hi Experts,

I have created a list box with a column that has values with a '~' separator.

But, I am unable to select the nodes. I can only select the child values in the tree.

Can someone please suggest whats wrong with it.

Please find attached the QVW file.

Regards,

Shyam.

[MarcoWedel]

You have to include the nodes as seperate values in the field.

[shyamcharan]

Hi Marco,

Thanks for the response.

Can you please correct me if I am wrong.

Were you saying that the values in the field should not be one with a '~' seperator?

Then whats the purpose of having the tree structure with a separator option.

Also, one particular node is working fine where i am able to select but none other work like that.

Just wondering why?

Thanks in advance for any thoughts on this .

[MarcoWedel · Accepted solution]

Hi,

one possible solution:

tabPlantAreaDesc:
LOAD PLANT_AREA_DESCRIPTION_TREE
FROM  (biff, embedded labels, table is Sheet1$);

LOAD Distinct
  SubField(PLANT_AREA_DESCRIPTION_TREE, '~', 1) as PLANT_AREA_DESCRIPTION_TREE
Resident tabPlantAreaDesc;

hope this helps

regards

Marco

[MarcoWedel]

maybe also helpful:

Tree View Hierarchy - select entire group?

regards

Marco

[shyamcharan]

Hi Marco,

Thanks heaps for your response. That helped me understand the issue and fix it. Thanks heaps.

-Regards,

Shyam.

[MarcoWedel]

You're welcome

regards

Marco