topic Create a hierarchy from three tables. in QlikView

Create a hierarchy from three tables.

Thu, 16 Dec 2010 10:35:49 GMT

Dear all,

I have the following Question:

I have three tables like this:

Field: A B C

Table 1: 1

Table 2: 1 2

Table 3: 2 3

Now i need to create a table the shows the folowing information:

Tabel 4: A B C

Row 1: 1 - -

Row 2: 1 2 -

Row 3: 1 2 3

It's a Hierachy. Does anyone know how to do this?

Regards,

Frank

suniljain — Thu, 16 Dec 2010 11:35:12 GMT

pls check attached file.

Thu, 16 Dec 2010 11:50:56 GMT

Thanks for your quick response!

I don't think this is my awnser (or maybe i am wrong).

Your Products ' hierarchy' is found inside ONE table 'Ancestors' , but I have THREE tables.

Thu, 16 Dec 2010 12:30:41 GMT

Hi fbeunder,

Could you please explain the problem with more data from each table1,table2 and table3?

Thu, 16 Dec 2010 12:52:03 GMT

Field: A B C

Table 1: 1

Table 2: 1 2

1 4

2 2

Table 3: 2 3

4 5

Tabel 4: A B C

Row 1: 1 - -

Row 2: 1 2 -

Row 3: 1 2 3

Row 4: 1 4 -

Row 5: 1 4 5

Row 6: 2 - -

Row 7: 2 2 -

Row 8: 2 2 4

Is this sufficient?