Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

MultiLanguage in qlikview

Hi All,

    How to use multilanguage in qlikview. Thank you in advance.

1 Solution

Accepted Solutions
fdelacal
Specialist
Specialist

i atacht one qvw. and one excel.

in excel you add the translation of the words.

and in main sheet of excel you choose the language you will charge!

in qvw. i create a variable vLanguage. and in description of titule you have to put.

=Minstring(if(REFERENCE = 'Seleccionar Idioma', $(vLanguage)))

where Seleccionar idioma, is the reference in excel.

see atachas!!

hope that helps you regards.

View solution in original post

10 Replies
fdelacal
Specialist
Specialist

i atacht one qvw. and one excel.

in excel you add the translation of the words.

and in main sheet of excel you choose the language you will charge!

in qvw. i create a variable vLanguage. and in description of titule you have to put.

=Minstring(if(REFERENCE = 'Seleccionar Idioma', $(vLanguage)))

where Seleccionar idioma, is the reference in excel.

see atachas!!

hope that helps you regards.

fdelacal
Specialist
Specialist

IT DON´T SOLVE YOUR PROBLEM?

WHY NOT ANSWER CORRECT?-

THERE ARE NOT OTHER WAY TO DO THIS.

Regards!

Not applicable
Author

Hi,

I can't open the QVW file with my qlik view it shows some error.Thank you for your help can you please share any materials instead of qvw file or is there any option to open the qvw file i cant open any qvw document download. Is  there anyway to overcome this problem

fdelacal
Specialist
Specialist

ok. i tell you what you will do.

create a qvw document.

in script paste this.(first downolad excel)

Language:

LOAD LANGUAGE,

     PHOTOLAN

FROM [Translation.xls] (biff, embedded labels, table is IDIOMAS$)

WHERE USADO='1';

Dictionary:

LOAD

    REFERENCE

FROM [Translation.xls] (biff, embedded labels, table is [DICCIONARIO$]);

FOR i=1 TO FIELDVALUECOUNT('LANGUAGE')

    LET campo= FIELDVALUE('LANGUAGE',$(i));

    JOIN(Dictionary)

    LOAD

        REFERENCE,

        $(campo)       

    FROM [Translation.xls] (biff, embedded labels, table is [DICCIONARIO$]);

NEXT

go to layout.

in design create a variable

vLanguage= add this value....  

=Minstring(LANGUAGE)

then create a text objet.

in text of it. add

=Minstring(if(REFERENCE = 'Seleccionar Idioma', $(vLanguage)))

then create 3 botton or 3 text objet.

i use an image in a text objet of the language i will select.

see image.

then change to the other 2 options.

='Portuguese'

='Spanish'

your text change

REGARDS! HOPE NOW I HELP YOU

Not applicable
Author

Hi Facundo,

           Thank you  very much. I get the solution exactly thank you once again

Not applicable
Author

Hi amelia,

Next to my view there is tab called new->Discussion->then it ask for your location you click browse location-> add your location(Eg.New to Qlik view)->You can get a editor->Post your question in that editor->specify any tags what type of question is yours->Post Message

Thanks and Regards

S.Amuthabharathi

Not applicable
Author

Hi ,

Can you post your question now

gumersindo
Contributor
Contributor

Thanks I used it in my application. It is very usefull.

Gracias!!!!  Me salvaste.

@kirkjoserey (twitter)

valerio_fatatis
Partner - Creator
Partner - Creator

Hi,

i have post the sib sample...

Look this

http://community.qlik.com/servlet/JiveServlet/downloadBody/5417-102-1-6528/QlikTemplate_Ver_1%20by%2...

valerio fatatis - Sebior BI Qlik Specialist