Hierarchy

[#1]

Hi,

Please suggest me about the input table for HIerarchy,

Suppose i have two table

Product table 1:

Product ID Product Name Productclassid1

1 Aspirin 1

2 Metacin 2

Product Name1 Productclassid1

Cold Remedies 1

Cold Remedies 2

How can i use node id and parent id realtion ship if this is the table from database

Thks in advance

[deepakk]

HI,

Check out the below discussion

http://community.qlik.com/forums/p/27820/107479.aspx#107479

Rajesh has attach a sample application for Hierarchy.

[marcohadiyanto]

hi,

hierarchy (ProductId2,ProductId1,ProductName2,ProducttName1,Path)

Load

ProductId2,

ProductId1,

ProductName2,

Resident Product;