Language Translations

[#1]

Hi

I want to translate the labels to other language.

This is my sample data

English	Spanish	Dutch
Current selections	Entre las selecciones actuales	huidige selecties
Trade Sector	sector Comercio	handelssector
Country	país	land
Branch	rama	tak
Underwriter	asegurador	assuradeur

By default it should display ENGLISH. When is select Spanish, Only the labels should be converted into spanish.

Please help me with this. Attached is the QVW

Thanks & Regards,

Keerthi

[alexandros17]

With a variable you have to hide/show objects (like multiselections), in this way you show the correct Language,

for descriptions use if statement testing the Language ...

Hope it helps

[jvishnuram]

Hi Keerthi,

Find the attachment hope it will helps you.

[#4]

Hi Alessandro,

I just took 3 languages. What if i have some 10 languages and also i will be having many fields.

Changing in all the places with if statement reduces the performance.

Thanks & Regards,

keerthi

[sudeepkm · Accepted solution]

I've modified your example like the attached one. Please let me know if you have any questions. Please look at the Sheet2 in xls and in QVW file.

[#6]

Thanks Sudeep

This is how my data to be displayed.

[Anonymous]

1. Create and load tables Language and Translation in your data maodel / qvw:

Languages :

load * inline

[

Language, abbrev

English ,  E

Spanish,   S

Dutch,   D

];

Transalation:

LOAD English,

     Spanish,

     Dutch,

     RowNo() as num

FROM

Language.xlsx

(ooxml, embedded labels, table is Sheet1);

2. create two buttons set action select in field Field name Language then Sarch string English like wise for all.

3. create a variable and set Language = $(vLanguage)    where vLanguage = Language    in setting Document properties. 

4.  In your charts go to expression tab  where you see two boxes one definition and other Label

in label box enter expression     fieldvalue($(vLanguage) ,3)  what it will do it will choose the the 3 no transalation

as defined in your transalation table which is Country  if you click English button or país if you click spanish button

and land if dutch button .

anant

[#8]

Hi

I want to translate the Fields to other language.I have attached the Excel below

Please help me with this.

Thanks in advance,

Soumya

[#9]

Hi Soumya,

You can use the below expression.

=Only({$<Index={2}>}Fields)

Change the Index number based on the fields.

Hope it helps.

Regards,

Keerthi

[#10]

Thanks a lot keerthi