Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multilanguage QVs

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

1 Solution

Accepted Solutions
luciancotea
Specialist
Specialist

Define a table with your translations:

KEYENROHU
1SalesVanzariÉrtékesítési
2ComputerCalculatorSzámítógép
3UserUtilizatorFelhasználó
4Last reloadUltima actualizareUtolsó frissítés
5DurationDurataIdő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

View solution in original post

4 Replies
luciancotea
Specialist
Specialist

Define a table with your translations:

KEYENROHU
1SalesVanzariÉrtékesítési
2ComputerCalculatorSzámítógép
3UserUtilizatorFelhasználó
4Last reloadUltima actualizareUtolsó frissítés
5DurationDurataIdő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

Not applicable
Author

Thanks Lucian.

Not applicable
Author

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.

Capture.PNG

luciancotea
Specialist
Specialist

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.