topic Re: Re: Tree List box issue in QlikView

Tree List box issue

shyamcharan — Fri, 07 Nov 2014 04:31:37 GMT

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.

Re: Tree List box issue

MarcoWedel — Fri, 07 Nov 2014 06:41:43 GMT

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

Re: Tree List box issue

shyamcharan — Sat, 08 Nov 2014 13:49:46 GMT

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 .

Re: Re: Tree List box issue

MarcoWedel — Sat, 08 Nov 2014 14:26:58 GMT

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

Re: Re: Tree List box issue

MarcoWedel — Sat, 08 Nov 2014 14:28:12 GMT

maybe also helpful:

Tree View Hierarchy - select entire group?

regards

Marco

Re: Re: Tree List box issue

shyamcharan — Tue, 11 Nov 2014 22:32:40 GMT

Hi Marco,

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

-Regards,

Shyam.

Re: Tree List box issue

MarcoWedel — Tue, 11 Nov 2014 23:12:15 GMT

You're welcome

regards

Marco