topic Re: Multilanguage QVs in QlikView

Multilanguage QVs

Tue, 20 Dec 2011 12:22:15 GMT

Hi all,

What is the best and easiest way to have a single QV document available in several languages? I mean, labels, text, etc.. Is the entering an expression into General > Settings for Selected Field > Label, for example, the only solution?

For example: =if(vLang = 'FRA','Bon jour', if(vLang = 'CRO','Bok', 'Hello'))

Thanks a lot,

Nenad

Re: Multilanguage QVs

luciancotea — Tue, 20 Dec 2011 12:31:55 GMT

Define a table with your translations:

KEY	EN	RO	HU
1	Sales	Vanzari	Értékesítési
2	Computer	Calculator	Számítógép
3	User	Utilizator	Felhasználó
4	Last reload	Ultima actualizare	Utolsó frissítés
5	Duration	Durata	Időtartam

Define a variable vLanguage where you set desired language (EN, RO, HU) using inputbox or buttons. Then use minstring( if(KEY=1, $(vLanguage))) in labels, where you set KEY = proper ID

Multilanguage QVs

Thu, 05 Jan 2012 14:04:01 GMT

Thanks Lucian.

Re: Multilanguage QVs

Wed, 13 Mar 2013 12:12:33 GMT

Hello,

I have a question related to this formulas. I started to work on changing the labels using minstring function from the answer and almost everything is working fine for me.

The only problem I have is in container objects. When I put this formula as a label of the tab in container it doesn't change into the value, but show the formula itself (screenshot attached for reference).

Could you please advise how to solve this problem.

Re: Multilanguage QVs

luciancotea — Wed, 13 Mar 2013 20:10:30 GMT

You're right, it doesn't work using the container label. Instead, use the original caption of the object to enter your expression and leave the tab label empty. This way it works.