topic Re: Language conversion in Qlikview in QlikView

Language conversion in Qlikview

abhaysingh — Wed, 24 Jun 2015 10:39:37 GMT

Hey Every one,

i want to know how a language conversion can be done in qlikview,

i.e, English to german,french etc.

can any one share application with me.

thanks

Re: Language conversion in Qlikview

alexandros17 — Wed, 24 Jun 2015 10:41:14 GMT

This is an example

Re: Language conversion in Qlikview

Siva_Sankar — Wed, 24 Jun 2015 11:46:01 GMT

Abhay,

// The structure of your language file should contain a column per language, where the column header contains the language ID or language name:

LOAD * INLINE [

English, German

Hello, Hallo

This is a test, Dies ist ein Test

];

// Then it is a advisable to create a separate table where the user can choose the language from, each value of field Language must match one the field names of your prev table:

Languages:

LOAD * INLINE [

Language

English

German

];

// Thats all it needs in the script.

In the front end, create a variable vLanguage in the variable overview:

=chr(39)&Language&chr(39)

Then create a list box form field Language, select one Language and enter properties - general tab an select option 'Always one value selected'

That's mostly it. For any text you need to translate, use an expression. For this example, create two text boxes:

=FieldValue($(vLanguage),1)

=FieldValue($(vLanguage),2)

The first text box will print out a welcome text, the second the test text, translated in the selected language.

Re: Language conversion in Qlikview

Siva_Sankar — Wed, 24 Jun 2015 11:47:20 GMT

Can be achieved in two ways. Check the blog for more information https://community.qlik.com/blogs/qlikviewdesignblog/2012/11/30/handling-multiple-languages

Regards,

Siva