topic Using Hierarchy with multiple values in tables in QlikView

Using Hierarchy with multiple values in tables

Thu, 08 Mar 2012 11:20:00 GMT

I'm trying to use the Hierarchy key word in a structured multi lingual environment.

My source table is as below:

ID Parent ID Location_EN Location_FR

1 UK Royaume Uni

2 1 London Londres

The result I would like to get is:

ID Parent ID Location_EN1 Location_EN2 Location_FR1 Location_FR2

1 UK Royaume Uni

2 1 UK London Royaume Uni Londres

I tried doing two hierarchy on the same table, but the result is two tables instead of one

Message was edited by: Philippe Franck

Using Hierarchy with multiple values in tables

jvitantonio — Thu, 08 Mar 2012 11:24:56 GMT

Can you please post your application with sample data?

Re: Using Hierarchy with multiple values in tables

jagan — Thu, 08 Mar 2012 11:52:59 GMT

Hi,

Please check the attachment. Hope it helps you.

Regards,

Jagan.

Using Hierarchy with multiple values in tables

Thu, 08 Mar 2012 12:01:28 GMT

I attached a qvw file with some sample data.

Using Hierarchy with multiple values in tables

Thu, 07 Jun 2012 15:02:09 GMT

My solution: I placed 6 listboxes (one per language) with the 6 fields and hide the 5 unrelevant boxesby using the conditional display of objects based on current language.