Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Using Hierarchy with multiple values in tables

Hi

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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Using Hierarchy with multiple values in tables

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.

4 Replies
Luminary
Luminary

Using Hierarchy with multiple values in tables

Can you please post your application with sample data?

MVP
MVP

Re: Using Hierarchy with multiple values in tables

Hi,

Please check the attachment.  Hope it helps you.

Regards,

Jagan.

Not applicable

Using Hierarchy with multiple values in tables

I attached a qvw file with some sample data.

Not applicable

Using Hierarchy with multiple values in tables

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.

Community Browser