topic Re: Re: Language Translations in QlikView

Language Translations

Wed, 22 Jan 2014 09:21:36 GMT

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

Re: Language Translations

alexandros17 — Wed, 22 Jan 2014 09:32:01 GMT

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

Re: Re: Language Translations

jvishnuram — Wed, 22 Jan 2014 09:41:21 GMT

Hi Keerthi,

Find the attachment hope it will helps you.

Re: Language Translations

Wed, 22 Jan 2014 09:43:59 GMT

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

Re: Language Translations

sudeepkm — Wed, 22 Jan 2014 09:47:03 GMT

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.

Re: Language Translations

Wed, 22 Jan 2014 09:55:43 GMT

Thanks Sudeep

This is how my data to be displayed.

Re: Language Translations

Anonymous — Wed, 22 Jan 2014 10:27:42 GMT

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

Re: Re: Language Translations

Thu, 23 Jan 2014 09:59:44 GMT

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

Please help me with this.

Thanks in advance,

Soumya

Re: Language Translations

Fri, 24 Jan 2014 05:31:15 GMT

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

Re: Re: Language Translations

Fri, 24 Jan 2014 06:22:55 GMT

Thanks a lot keerthi