topic Hierarchy in QlikView

Hierarchy

Wed, 29 Dec 2010 06:42:37 GMT

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 — Wed, 29 Dec 2010 07:09:54 GMT

HI,

Check out the below discussion

Rajesh has attach a sample application for Hierarchy.

marcohadiyanto — Wed, 29 Dec 2010 07:51:10 GMT

hi,

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

Load

ProductId2,

ProductId1,

ProductName2,

Resident Product;