topic Hierarchy in QlikView

Hierarchy

Mon, 27 Dec 2010 09:25:12 GMT

Hi,

Please suggest me to create hierarchy using flat table structure,

Ex;

Product Table 1:

Product_Class1_ID ProductClass1Name

1 Cold Remedies

2 Cold Remedies

3 Summer Remedies

Product Table 2:

ProductClass2_ID ProductClass2_name ProductClass1_ID

1 Anacin 1

2 Metacin 2

3 Paracitamol 3

I want o/p like

Cold Remedies

Anacin

Metacin

Summer Remdies

Paracitamol

i have used hierarchy and hierarchy function not able to acheieve correct o/p.

thks in advance

Hierarchy

Mon, 27 Dec 2010 12:02:58 GMT

Hello prabhu,

when I understood you right, you want to create dimensional levels on your productclasses. In this case you can link your classes together using the "ProductClass1_ID". Rename it to "Product_Class1_ID" (same as in table 1, take care of case sensitivity) and QV will link both tables together and you will have the desired productclasses hierarchy.

Regards, Roland

Hierarchy

Tue, 28 Dec 2010 08:04:21 GMT

Hi Roland,

Hierarchy

Tue, 28 Dec 2010 08:06:53 GMT

Hi Roland,

Thks for the reply.

I need to know the input table for this example,

Product Table 1:

Product_Class1_ID ProductClass1Name

1 Cold Remedies

2 Cold Remedies

3 Summer Remedies

Product Table 2:

ProductClass2_ID ProductClass2_name Product_Class1_ID

1 Anacin 1

2 Metacin 2

3 Paracitamol 3

how to use this example using qlikview hierarchy

thks in advance

Hierarchy

Tue, 28 Dec 2010 08:43:57 GMT

Hi,

See the attached qvw.

Reg,

Shubhasheesh

Hierarchy

Tue, 28 Dec 2010 10:56:00 GMT

Hi prabhu

Please find the attachment.

Hope its useful to you.

Thanks & Regards,

Sri

Hierarchy

Tue, 28 Dec 2010 16:38:36 GMT

Hello again,

I used the data from your first post.

Take a look at the script and at the table viewer. You do not need the hierarchy statement. QV links to tables automatically together with same fieldnames. With this in mind I linked your two tables and recieved the hierarchy you want. Or I am completly wrong? BTW: why do have Cold Remedies two different IDs ?

Re: Hierarchy

Mon, 02 Apr 2012 20:17:11 GMT

Can we display parent child relationship in Text boxes.

Actually i've a Country-->Region--->City kind of relationship in my structure & its needed to be in Text boxes as shown in the file attached.

Plz help

Thanks