Hierarchy

[#1]

Hi All,

I display the country as tree in my report. But some thing is wrong.

If i click the higher order like "All Country" it is not working,  i have to collapse the tree and then click again the  "All Country" it works.

Appreciate if some one help me on this.

Tree:

Hierarchy (COUNTRY_ID, PARENT_ID, COUNTRY, Parent, COUNTRY, PathName)

Select  COUNTRY_ID,

PARENT_ID,

NAME AS COUNTRY

From XX_JLR_MS_COUNTRY ;

Tree_rel:

HierarchyBelongsTo (COUNTRY_ID , PARENT_ID, REGION_ID, COUNTRY , Test2)

LOAD

    COUNTRY_ID ,

     PARENT_ID,

     REGION_ID ;

SQL SELECT COUNTRY_ID, PARENT_ID, REGION_ID FROM XX_JLR_MS_COUNTRY;

Regions:

LOAD

     REGION_ID,

     REGION_NAME;

SQL SELECT REGION_ID,REGION_NAME FROM XX_JLR_MS_REGION;

Thanks,

Subramanian

[whiteline]

Hi.

Seems it works like it should.

When you select using collapsed tree, QV assumes that you want select all nodes that are connected.

When you select using expanded tree, QV assumes that you want select the parent node.

http://community.qlik.com/docs/DOC-3899